- 论坛徽章:
- 1
|
本帖最后由 chinafenghao 于 2013-10-30 13:48 编辑
mysql> source pet.sql
Query OK, 0 rows affected (0.01 sec)
+----------------+
| Tables_in_test |
+----------------+
| l2 |
| pet |
| user |
+----------------+
3 rows in set (0.00 sec)
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
Query OK, 8 rows affected, 7 warnings (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 7
mysql> select * from pet;
显示有7条warnings. 怎么在执行sql语句时把warning显示出来呢?
|
|