摘要:
将字段格式为2013-08-09 13:22:55转换为时间戳UPDATE `AttendClass` SET `regdate` = unix_timestamp(regDate2) WHERE `rowid` = 118280;将字段name前面添加一个字符xupdate aa set name=concat('x',name)MYSQL查询重复记录的方法1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select * from people where peopleId in (select peopleId from people group 阅读全文