MySQL 基础 一

--增
insert into `表名` (`id`,`age`) values('1','18');
--删
delete from `表名` where `id` = 1;
--改
update `表名` set `age` = 19 where `id` =1;
--查
select * from `表名` ;

修改字段值某部分

update AA set aa = replace(aa,'标准','规范') where aa like '%标准%'

查询某个字段值中包含某个值

SELECT * from test where FIND_IN_SET('5',follow_id);

-- 数据导出
select * from `tp_users` into outfile './sql.txt' lines terminated by '\r\n' ; 
-- 导入在 mysql / data 下
-- 如果出现 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
--则 使用 SHOW VARIABLES LIKE "secure_file_priv"; 查看 secure_file_priv = 的路径 如果value 为null 则禁止 为空则不限制目录