windows下,再不指定数据库的情况下,建立存储过程或函数,会让mysql5自动停止服务D:\mysql50\bin>mysql -uroot -P3308 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.15-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> delimiter // mysql> CREATE FUNCTION `getdate`() RETURNS varchar(19) -> BEGIN -> return now(); -> END; -> // ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> AbortedD:\mysql50\bin>telnet localhost 3308 正在连接到localhost...无法打开到主机的连接 在端口 3308 : 连接失败
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.15-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> delimiter //
mysql> CREATE FUNCTION `getdate`() RETURNS varchar(19)
-> BEGIN
-> return now();
-> END;
-> //
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> AbortedD:\mysql50\bin>telnet localhost 3308
正在连接到localhost...无法打开到主机的连接 在端口 3308 : 连接失败
在tools里面
windows下,再不指定数据库的情况下,建立存储过程或函数,会让mysql5自动停止服务
-------------------------------------------------------------------------------
这是BUG, 5.0.16将FIXMYSQL的存取过程还有很多没完善的地方.
EngInSite MySQL Client这两个图形化的工具都不错