linux mysql query_Linux下MySQL的简单操作

一些基本的MySQL操作命令

1. 查询当前的库

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| test |

+--------------------+

3 rows in set (0.06 sec)

mysql的命令，结尾处需要加一个分号。

2. 查询某个库的表

首先需要切换到某个库里去:

mysql> use mysql;

Database changed

然后再把表列出来:

mysql> show tables;

+---------------------------+

| Tables_in_mysql |

+---------------------------+

| columns_priv |

| db |

| event |

| func |

| general_log |

| help_category |

| help_keyword |

| help_relation |

| help_topic |

| host |

| ndb_binlog_index |

| plugin |

| proc |

| procs_priv |

| servers |

| slow_log |

| tables_priv |

| time_zone |

| time_zone_leap_second |

| time_zone_name |

| time_zone_transition |

| time_zone_transition_type |

| user |

+---------------------------+

23 rows in set (0.06 sec)

3. 查看某个表的全部字段

mysql> desc slow_log;

+----------------+------------------+------+-----+-------------------+-----------------------------+

| Field | Type | Null | Key | Default | Extra |

+----------------+--