假设你的mysql安装路径如下,则C:\Program Files\nusphere\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.32Type 'help;' or '\h' for help. Type '\c' to clear the buffermysql> create database test_DB;
Query OK, 1 row affected (0.01 sec)mysql> use test_DB;
Database changedmysql> create table test_table (id int(11),name varchar(64));
Query OK, 0 rows affected (0.00 sec)mysql> desc test_table;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(64) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)mysql> exit
ByeC:\Program Files\nusphere\mysql\bin>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.32Type 'help;' or '\h' for help. Type '\c' to clear the buffermysql> create database test_DB;
Query OK, 1 row affected (0.01 sec)mysql> use test_DB;
Database changedmysql> create table test_table (id int(11),name varchar(64));
Query OK, 0 rows affected (0.00 sec)mysql> desc test_table;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(64) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)mysql> exit
ByeC:\Program Files\nusphere\mysql\bin>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货