Mysql資料庫在Linux下的使用

標籤：

1. 建立資料庫   

1.1 啟動Mysql

   

[[email protected] ~]# mysql -h127.0.0.1 -uroot -pmysql

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.6.24 MySQL Community Server (GPL)

   

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

   

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

   

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

   

1.2 建立資料庫

   

mysql> create database Kevindb1;

Query OK, 1 row affected (0.08 sec)

   

mysql> show databases;

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

| Database |

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

| information_schema |

| Kevindb1 |

| mysql |

| performance_schema |

| test |

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

5 rows in set (0.01 sec)

   

mysql>

   

2. 建立資料表

   

mysql> use Kevindb1;

Database changed

mysql> create table users(userID varchar(8),userName varchar(8));

Query OK, 0 rows affected (0.35 sec)

   

mysql> show tables;

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

| Tables_in_Kevindb1 |

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

| users |

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

1 row in set (0.00 sec)

   

3. 在user表中插入資料

   

mysql> insert into users values(‘0001‘,‘Tom‘);

Query OK, 1 row affected (0.08 sec)

   

mysql> insert into users values(‘0002‘,‘James‘);

Query OK, 1 row affected (0.04 sec)

   

mysql> select * from users;

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

| userID | userName |

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

| 0001 | Tom |

| 0002 | James |

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

2 rows in set (0.00 sec)

   

4. 查看錶結構

   

mysql> desc users;

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

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

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

| userID | varchar(8) | YES | | NULL | |

| userName | varchar(8) | YES | | NULL | |

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

2 rows in set (0.07 sec)

Mysql資料庫在Linux下的使用