docker启动mysql
代码语言：javascript复制docker run --name ssli -e MYSQL_ROOT_PASSWORD=admin -d mysql连接mysql
代码语言：javascript复制docker exec -it ssli bash
mysql -u root -p'admin'退出数据库
代码语言：javascript复制mysql> exit
Bye创建db
代码语言：javascript复制mysql> create database ssli;
mysql> show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| performance_schema |
| ssli |
| sys |
--------------------
5 rows in set (0.00 sec)创建table
代码语言：javascript复制mysql> create table ssli.test ( barcode text, goodsname text, price int );
mysql> describe ssli.test;
----------- ------ ------ ----- --------- -------
| Field | Type | Null | Key | Default | Extra |
----------- ------ ------ ----- --------- -------
| barcode | text | YES | | NULL | |
| goodsname | text | YES | | NULL | |
| price | int | YES | | NULL | |
----------- ------ ------ ----- --------- -------
3 rows in set (0.00 sec)
mysql> use ssli;
mysql> show tables;
----------------
| Tables_in_ssli |
----------------
| test |
----------------
1 row in set (0.00 sec)添加主键
代码语言：javascript复制mysql> alter table ssli.test add column id int primary key auto_increment;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> describe ssli.test;
----------- ------ ------ ----- --------- ----------------
| Field | Type | Null | Key | Default | Extra |
----------- ------ ------ ----- --------- ----------------
| barcode | text | YES | | NULL | |
| goodsname | text | YES | | NULL | |
| price | int | YES | | NULL | |
| id | int | NO | PRI | NULL | auto_increment |
----------- ------ ------ ----- --------- ----------------
4 rows in set (0.00 sec)向table中添加数据
代码语言：javascript复制mysql> insert into ssli.test ( barcode, goodsname, price ) values ('001', 'demo', 4);
Query OK, 1 row affected (0.00 sec)
mysql> select * from ssli.test;
--------- ----------- ------- ----
| barcode | goodsname | price | id |
--------- ----------- ------- ----
| 001 | demo | 4 | 1 |
--------- ----------- ------- ----
1 row in set (0.00 sec)
mysql> insert into ssli.test ( barcode, goodsname, price ) values ('002', 'demo2', 2);
Query OK, 1 row affected (0.00 sec)
mysql> select * from ssli.test;
--------- ----------- ------- ----
| barcode | goodsname | price | id |
--------- ----------- ------- ----
| 001 | demo | 4 | 1 |
| 002 | demo2 | 2 | 2 |
--------- ----------- ------- ----
2 rows in set (0.00 sec)LEo at 00:12
