MySQL 常用命令(1)

MySQL 4.1.7 Tune Performance Common Command
1. SHOW INNODB STATUS and the InnoDB Monitors
mysql> SHOW INNODB STATUS\G (Caution:must be end with \G);

2. insert into table(column_name) select clause...
INSERT INTO Table1 (latin1_column) SELECT USER();
3.显示当前MYSQL Version
select version()