mysql命令

启动：net start mySql;
停止：net stop mySql;

进入：mysql -u root -p/mysql -h localhost -u root -p databaseName;
提示语格式 ： mysql -uroot -p --prompt="\u@\h:\d \r:\m:\s> 或 prompt="\u@\h:\d \r:\m:\s>

列出数据库：show databases;
选择数据库：use databaseName;
列出表格：show tables；
显示表格列的属性：show columns from tableName；
建立数据库：source fileName.txt;

查看数据库引擎：show engines;
查看当前数据库：show tables;
查看数据库状态：status;
查看数据库表创建信息： show create table tableName;
查看表信息: describe tableName;

查询性能: explain select *　from tableName;
alter table users change usrid usrid smallint auto_increment;

3, 慢查询
Java代码
mysql> show variables like '%slow%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| log_slow_queries | OFF |
| slow_launch_time | 2 |
+------------------+-------+
mysql> show global status like '%slow%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| Slow_launch_threads | 0 |
| Slow_queries | 279 |
+---------------------+-------+

4, 连接数

Java代码
mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 500 |
+-----------------+-------+

mysql> show global status like 'max_used_connections';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 498 |
+----------------------+-------+