cmd+mysql+测试_测试中用到的MySQL命令

Restart mysql:

sudo /etc/init.d/mysql restart;

mysql -uroot -proot #connect to mysql

mysql> use

mysql> show tables;

mysql> select * from

mysql> delete from

mysql> desc

mysql> show variables like '%set%'; #显示数据库使用的编码

mysql> insert into

mysql> insert into

mysql> update

mysql> select length() from

mysql> source /home/XX/Documents/XX/Proc/testProc_Usages.sql #MySQL 命令行下执行.sql脚本

mysql> update traffic_stats set query_time  = query_time - INTERVAL 5 day;