sql根据身份证号算年龄
摘要:select (year(NOW())- substring(ages,7,4)) age from `user`
阅读全文
数据库删除重复数据 sql
摘要:delete from `user`where id in( SELECT * from(select id from `user` WHERE id not in (select min(id) from `user` group by names having count(names)>1) )
阅读全文