# 命令行操作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  **插入数据** INSERT INTO `tp_yuju` (name,password,create\_time) VALUES('测试001','123456','2021-03-23')  **查询数据** SELECT `name` FROM `tp_yuju` WHERE id=1  **更新数据** UPDATE `tp_yuju` SET `name`='修改后的数据' WHERE id=1  **删除数据** DELETE FROM `tp_yuju` WHERE id=1  **模糊查询** SELECT \* FROM `tp_yuju` WHERE `name` LIKE '测试%'