mysql 命令符操作登陆 展开 查看对象 查看数据表名称 数据表结构 插入

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql> use test;
Database changed
mysql> desc user
    ->
    ->
    ->
    ->
    -> desc user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'desc
user' at line 6
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| a              |
| b              |
| boy            |
| category       |
| girl           |
| goods          |
| m              |
| mian           |
| result         |
| t              |
| user           |
+----------------+
11 rows in set (0.00 sec)

mysql> desc user;
+-------+----------------------+------+-----+---------+----------------+
| Field | Type                 | Null | Key | Default | Extra          |
+-------+----------------------+------+-----+---------+----------------+
| uid   | int(11)              | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20)          | NO   |     |         |                |
| age   | smallint(5) unsigned | NO   |     | 0       |                |
+-------+----------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> insert into user (uid,name,age) values (1,'lisi',23);
Query OK, 1 row affected (0.00 sec)

mysql> select * form user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'form
user' at line 1
mysql> select * from user;
+-----+------+-----+
| uid | name | age |
+-----+------+-----+
|   1 | lisi |  23 |
+-----+------+-----+
1 row in set (0.00 sec)

mysql> insert into user (uid,name) values (2,'lucy');
Query OK, 1 row affected (0.00 sec)

mysql> select * from user;
+-----+------+-----+
| uid | name | age |
+-----+------+-----+
|   1 | lisi |  23 |
|   2 | lucy |   0 |
+-----+------+-----+
2 rows in set (0.00 sec)

mysql> insert into user (name) values('lilei');
Query OK, 1 row affected (0.00 sec)

mysql> select * from user;
+-----+-------+-----+
| uid | name  | age |
+-----+-------+-----+
|   1 | lisi  |  23 |
|   2 | lucy  |   0 |
|   3 | lilei |   0 |
+-----+-------+-----+
3 rows in set (0.00 sec)

mysql> desc user;
+-------+----------------------+------+-----+---------+----------------+
| Field | Type                 | Null | Key | Default | Extra          |
+-------+----------------------+------+-----+---------+----------------+
| uid   | int(11)              | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20)          | NO   |     |         |                |
| age   | smallint(5) unsigned | NO   |     | 0       |                |
+-------+----------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> insert into user values (4,'white','36');
Query OK, 1 row affected (0.00 sec)

mysql> select * from user;
+-----+-------+-----+
| uid | name  | age |
+-----+-------+-----+
|   1 | lisi  |  23 |
|   2 | lucy  |   0 |
|   3 | lilei |   0 |
|   4 | white |  36 |
+-----+-------+-----+
4 rows in set (0.00 sec)

mysql>