命令行操作MYSQL · 常用筆記

# 命令行操作MYSQL **創建數據表** CREATE TABLE IF NOT EXISTS `tp_yuju`( `id` INT UNSIGNED AUTO\_INCREMENT, `name` VARCHAR(50) NOT NULL, 'password' VARCHAR(50) NOT NULL, `create_time` DATE, PRIMARY KEY('id') ) ENGINE = InnoDB DEFAULT CHARSET=UTF8 ![](https://img.kancloud.cn/c7/6e/c76ec8929b420231cdbdd5f7fc9125c0_436x160.png) **插入數據** INSERT INTO `tp_yuju` (name,password,create\_time) VALUES('測試001','123456','2021-03-23') ![](https://img.kancloud.cn/81/58/8158f3827056492f29f624aa6323d041_524x201.png) **查詢數據** SELECT `name` FROM `tp_yuju` WHERE id=1 ![](https://img.kancloud.cn/87/a2/87a26270a0ea2dba7218c9888a5e6ccb_572x364.png) **更新數據** UPDATE `tp_yuju` SET `name`='修改后的數據' WHERE id=1 ![](https://img.kancloud.cn/c2/15/c215801f54be4524d39d9719dfeac6ef_551x327.png) **刪除數據** DELETE FROM `tp_yuju` WHERE id=1 ![](https://img.kancloud.cn/9d/93/9d93f0263d09c629a4cc18cfaa52f13c_506x254.png) **模糊查詢** SELECT \* FROM `tp_yuju` WHERE `name` LIKE '測試%' ![](https://img.kancloud.cn/fc/87/fc87fc68593bcf9db2645939e56c5d74_563x360.png)