如何在MySQL中使用select语句调用存储过程？

在 MySQL 中，无法在 FROM 子句中使用 select from procedure。您可以使用CALL命令，然后可以执行SELECT语句。

让我们首先创建一个表：

mysql> create table DemoTable2 -> ( -> CustomerId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> CustomerName varchar(100), -> ShippingDateTime datetime -> ); Query OK, 0 rows affected (0.66 sec)登录后复制

mysql> DELIMITER // mysql> CREATE PROCEDURE insert_information(Name varchar(100),shippingtime datetime) -> BEGIN -> -> INSERT INTO DemoTable2(CustomerName,ShippingDateTime) VALUES(Name,shippingtime); -> END -> // Query OK, 0 rows affected (0.16 sec) mysql> DELIMITER ;登录后复制

mysql> call insert_information('Chris',NOW()); Query OK, 1 row affected, 1 warning (0.15 sec)登录后复制

mysql> select *from DemoTable2;登录后复制

+------------+--------------+---------------------+ | CustomerId | CustomerName | ShippingDateTime | +------------+--------------+---------------------+ | 1 | Chris | 2019-04-08 15:03:07 | +------------+--------------+---------------------+ 1 row in set (0.00 sec)登录后复制