Mysql基礎操作（命令行）

背景

docker安裝mysql8，映射本地端口3306

創建數據庫

 create database myblog charset=utf8;

選擇數據庫

use myblog;

查看所有表

show tables;

查看表結構

desc mm_t_user;

show columns from mm_t_user;

向表插入數據

插入第一條

insert into mm_t_user (insert_time,update_time,deleted,number,name,phone,content)
VALUES('2023-11-24','2023-11-24','0','1001','mm','13654854562','很厲害');

插入第二條

insert into mm_t_user (insert_time,update_time,deleted,number,name,phone,content)
VALUES('2023-11-24','2023-11-24','0','1002','Krystal','13654854563','很厲害嗎');

插入第三條

insert into mm_t_user (insert_time,update_time,deleted,number,name,phone,content)
VALUES('2023-11-24','2023-11-24','0','1003','ck','13654854564','很帥氣');

查詢表數據

select * from mm_t_user 

修改表數據

UPDATE mm_t_user SET content='ck' WHERE id=5;

刪除表數據

DELETE FROM mm_t_user WHERE id=4;