发布时间:2015-03-17 14:53:30
SET @var = '123';SET @strsql = concat('alter table tablenamexxx auto_increment=', @var);PREPARE stmt FROM @strsql;EXECUTE stmt;......【阅读全文】
发布时间:2015-02-01 18:59:09
delete from my_table_name where id not in(select * from (SELECT min(id) FROM my_table_name group by `col1`,`col2`) as t1) limit 1000;......【阅读全文】