mysql note

1.mysql修改密碼

mysqladmin -u root -p password mypasswd

例子mysqladmin -u root -p password 1234

2.判断MySql某个数据库是否存在

SELECT * FROM information_schema.SCHEMATA where SCHEMA_NAME='aa';

3.查询mysql数据库中所有表名

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库名'

4.mysql server has gone away解決

//my.ini
wait_timeout=2880000 
interactive_timeout = 2880000 
max_allowed_packet = 300M

參考
http://jingyan.baidu.com/article/ea24bc399f6bb9da62b3311c.html?qq-pf-to=pcqq.c2c