我將MySQL常用指令整理出來分享給大家。

1.?列出所有數據庫

mysql> show databases;

2.?創建數據庫

mysql> create databases MyStorage;

3.?打開數據庫

mysql> use MyStorage;

4.?創建表

mysql> create table Storage

-> (

-> id int,

-> name varchar(50),

-> price float,

-> type nvarchar(50),

-> number int,

-> makeTime date,

-> useDay int);

5.?顯示所有的表

mysql> show tables;

6.?顯示表詳細信息

mysql> describe storage;

7.?將文本文件sotrage.txt中的記錄導入到表中

mysql> load data local infile 'e:/storage.txt' into table storage

-> lines terminated by '/r/n';

8.?顯示表中的記錄

mysql> SELECT * FROM storage;

9.?向表中插入記錄

mysql> insert into storage

-> values (8,'風衣',300,'服裝',3650,'2011-3-1',0);

10.?刪除表中的記錄

mysql> delete from storage where id=8;

11.?修改表中的記錄

mysql> update storage set price=1000 where id=7;

12.?顯示mysql中所有賬戶

mysql> show databases;

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

| Database?????????? |

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

| information_schema |

| mysql????????????? |

| mystorage????????? |

| test?????????????? |

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

4 rows in set (0.00 sec)

mysql> use mysql;

Database changed

mysql> show tables;

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

| Tables_in_mysql?????????? |

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

| columns_priv????????????? |

| db??????????????????????? |

| func????????????????????? |

| help_category???????????? |

| help_keyword????????????? |

| help_relation???????????? |

| help_topic??????????????? |

| host????????????????????? |

| proc????????????????????? |

| procs_priv??????????????? |

| tables_priv?????????????? |

| time_zone???????????????? |

| time_zone_leap_second???? |

| time_zone_name??????????? |

| time_zone_transition????? |

| time_zone_transition_type |

| user????????????????????? |

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

17 rows in set (0.00 sec)

mysql> select * from user;+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+| Host????? | User | Password????????????????????????????????? | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |?Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv?| Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv| ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+| localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | Y?????????? |?Y???????????? | Y??????????? | Y???????? | Y????????? | Y?????????????? | Y????? | Y????????? | Y??????????? | Y????????? | Y???????????????????? | Y????????? | Y??????????? | Y?????????????? | Y??????????????? | Y?| Y????????????? | Y?????????????????? | Y????????????????? | Y|????????? |??????????? |???????????? |????????????? |???????????? 0 |?0 |?????????????? 0 |??????????????????? 0 |+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+1 row in set (0.00 sec)