OS: Redhat as 3
新安装 MySQL 5.0.22 , 操作如下: mysql> create database abc;
Query OK, 1 row affected (0.00 sec)
mysql> use abc
Database changed mysql> select database(), user();
+------------+----------------+
| database() | user() |
+------------+----------------+
| abc | root@localhost |
+------------+----------------+
1 row in set (0.00 sec)
mysql> show tables;
Empty set, 1 warning (0.00 sec)
mysql> create table abc123( id int ) ;
ERROR 1050 (42S01): Table 'abc123' already exists
在数据库中, 总提示表已经存在, 为什么呢? 应该从哪里入手查原因呢?
mysql> show tables;
Empty set, 1 warning (0.00 sec)如何查看这个 warning 的信息呢?