测试中用到的MySQL命令 Anny

Restart mysql:
sudo /etc/init.d/mysql restart;

mysql -uroot -proot <database> #connect to mysql

mysql> use <database>

mysql> show tables;

mysql> select * from <table>;

mysql> delete from <table> where <condition>;

mysql> desc <table>; #表结构

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

mysql> insert into <table> <field>  values ('<value>');

mysql> insert into <table>  values ('<value1>','<value2>');

mysql> update <table> set <filed> = '<value>';

mysql> select length(<field>) from <table>;#得到字段值当前的长度

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

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