mysql 数据库学习笔记

1.连接数据库

mysql -u root -p123456

2.查看数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| zabbix             |
+--------------------+

3.选择使用的数据库，如db_sysdev

mysql> use db_sysdev;
Database changed

4.查看表

mysql> show tables
    -> ;
+---------------------+
| Tables_in_db_sysdev |
+---------------------+
| tb_devs_info        |
+---------------------+
1 row in set (0.00 sec)

5.创建表，必须包含一个字段名并且规定字段的数据类型

mysql> create table tb_devs_info
    -> (
    -> name char(64) not null
    -> )engine=innodb;

6.修改表的名称

mysql> alter table tb_devs_info rename to tb_dev_info;
Query OK, 0 rows affected (0.11 sec)

7.修改表中，字段的数据量类型

mysql> alter table tb_devs_info change column name name varchar(64);
Query OK, 0 rows affected (0.47 sec)