1. 查看数据库

  1. --- 查看数据库
  2. MariaDB [(none)]> show databases;
  4. +--------------------+
  5. | Database           |
  6. +--------------------+
  7. | information_schema |
  8. | mysql              |
  9. | performance_schema |
  10. +--------------------+
  11. 3 rows in set (0.00 sec)

2. 创建数据库

  1. -- 创建数据库
  2. MariaDB [mysql]> create database chen_userInfo;
  3. Query OK, 1 row affected (0.01 sec)
  5. --- 再次查看
  6. MariaDB [mysql]> show databases;
  7. +--------------------+
  8. | Database           |
  9. +--------------------+
  10. | chen_userInfo      |
  11. | information_schema |
  12. | mysql              |
  13. | performance_schema |
  14. +--------------------+
  15. 4 rows in set (0.00 sec)
  1. ---过滤 查看
  2. MariaDB [(none)]> show databases like 'chen%';
  3. +------------------+
  4. | Database (chen%) |
  5. +------------------+
  6. | chen_userInfo    |
  7. +------------------+

3. 创建表

  1. --- 选中数据库
  2. MariaDB [(none)]> use chen_userInfo
  3. Database changed
  5. --- 创建表
  6. MariaDB [chen_userInfo]> CREATE TABLE user_info
  7.     ->      (
  8.     ->      id INT(11),
  9.     ->      name VARCHAR(25),
  10.     ->      age INT(11),
  11.     ->      tel INT (11),
  12.     ->      email VARCHAR (60),
  13.     ->      info VARCHAR(100)
  14.     ->      );
  15. Query OK, 0 rows affected (0.28 sec)
  1. --- 创建表的sql
  2. CREATE TABLE user_info
  3.      (
  4.      id INT(11),
  5.      name VARCHAR(25),
  6.      age INT(11),
  7.      tel INT (11),
  8.      email VARCHAR (60),
  9.      info VARCHAR(100)
  10.      );

4. 查看表

  1. --- 查看表
  2. MariaDB [chen_userInfo]> desc user_info;
  4. +-------+--------------+------+-----+---------+-------+
  5. | Field | Type         | Null | Key | Default | Extra |
  6. +-------+--------------+------+-----+---------+-------+
  7. | id    | int(11)      | YES  |     | NULL    |       |
  8. | name  | varchar(25)  | YES  |     | NULL    |       |
  9. | age   | int(11)      | YES  |     | NULL    |       |
  10. | tel   | int(11)      | YES  |     | NULL    |       |
  11. | email | varchar(60)  | YES  |     | NULL    |       |
  12. | info  | varchar(100) | YES  |     | NULL    |       |
  13. +-------+--------------+------+-----+---------+-------+
  14. 6 rows in set (0.01 sec)

5. 插入数据

  1. MariaDB [chen_userInfo]> INSERT INTO user_info
  2.     ->     (name,age,tel,email,info)
  3.     -> VALUES(
  4.     ->         'chenxzong',
  5.     ->         30,
  6.     ->         17186769803,
  7.     ->         'chenxzong@qq.com',
  8.     ->         'info of chenxzong'
  9.     ->         );
  10. Query OK, 1 row affected, 1 warning (0.00 sec)
  1. --  插入数据
  2. INSERT INTO user_info
  3.     (name,age,tel,email,info)
  4. VALUES(
  5.         'chenxzong',
  6.         30,
  7.         11111111111,
  8.         'chenx****@qq.com',
  9.         'info of chen***'
  10.         );

6.查询数据

  1. MariaDB [chen_userInfo]> select *  from user_info;
  2. +------+-----------+------+------------+------------------+-------------------+
  3. | id   | name      | age  | tel        | email            | info              |
  4. +------+-----------+------+------------+------------------+-------------------+
  5. | NULL | chenxzong |   30 | 2147483647 | chenxzong@qq.com | info of chenxzong |
  6. +------+-----------+------+------------+------------------+-------------------+
  7. 1 row in set (0.00 sec)