①插入新用户,并哈希化
insert into users(name,email,password,role) values('user13','user13@test.com',crypt('0000', gen_salt('md5')),'healthcare');
②删除数据表中的指定数据
delete from migrations where id = 2;
③删除数据表
drop table users;
③更改数据表内容
UPDATE t_autodetect_location_master
SET master_location_name = 'F8'
WHERE id = 61;