Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
+--------------------+
| 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>
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
+--------------------+
| 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>