判断数据库是否有某条记录：select 1 from xxx where xxx (效率：1> colname > *)
清空表记录: truncate table xxx > delete from xxx
多表查询： select * from xxx A left join xxx B on A.x = B.x where xxx > select * from xxx A where A.x in (select B.x from xxx B);
本文共 282 字，大约阅读时间需要 1 分钟。
判断数据库是否有某条记录：select 1 from xxx where xxx (效率：1> colname > *)
清空表记录: truncate table xxx > delete from xxx
多表查询： select * from xxx A left join xxx B on A.x = B.x where xxx > select * from xxx A where A.x in (select B.x from xxx B);
转载于:https://www.cnblogs.com/itpoorman/p/4422490.html