日期:2014-05-16 浏览次数:20808 次
?
mysql> use test; Database changed mysql> select @@version; +-----------+ | @@version | +-----------+ | 5.5.15 | +-----------+ 1 row in set (0.00 sec) mysql> select @@sql_mode; +----------------------------+ | @@sql_mode | +----------------------------+ | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +----------------------------+ 1 row in set (0.00 sec) mysql> show column from mytable; 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 'column from mytable' at line 1 mysql> show columns from mytable; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | a | int(11) | NO | PRI | NULL | | | b | char(18) | NO | | NULL | | +-------+----------+------+-----+---------+-------+ 2 rows in set (0.01 sec) mysql> use mysql; Database changed mysql> show index from db; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | db | 0 | PRIMARY | 1 | Host | A | NULL | NULL | NULL | | BTREE | | | | db | 0 | PRIMARY | 2 | Db | A | NULL | NULL | NULL | | BTREE | | | | db | 0 | PRIMARY | 3 | User | A | 0 | NULL | NULL | | BTREE | | | | db | 1 | User | 1 | User | A | 0 | NULL | NULL | | BTREE | | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 4 rows in set (0.00 sec) mysql> show privilges; 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 'privilges' at line 1 mysql> show create table user; +-------+--------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ | Table | Create Table | +-------+------