仗剑走天涯

Just Do It!
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

09 Mysql数据库在Linux下的使用

Posted on 2015-05-29 09:42  三颗油  阅读(145)  评论(0编辑  收藏  举报

1. 创建数据库   

1.1 启动Mysql

   

[root@localhost ~]# 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)