lansky54的专栏

添加远程用户admin密码为password GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY \'password\' WITH GRANT OPTION GRANT ALL PRIVILEGES ON *.* TO admin@\"%\" IDENTIFIED BY \'password\' WITH GRANT OPTI

mysql> delimiter // mysql> create procedure hello()     -> begin     -> select 'It is not a HelloWorld';     -> end     -> // Query OK, 0 rows affected (0.01 sec)其中“delimiter //”的意思是定义结束符号为“//