56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> delimiter //
mysql> create procedure p_dinoalex()
-> begin
-> declare sd datetime;
-> select max(orderdate) into sd from tx;
-> select sd;
-> end;
-> //
Query OK, 0 rows affected (0.23 sec)
mysql> delimiter ;
mysql> call p_dinoalex();
+---------------------+
| sd |
+---------------------+
| 2009-06-20 00:00:00 |
+---------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>