mysql小知识

插入行号:

select (@rowid:=@rowid+1) as rowNo,table.* from table,(select (@rowid:=0)) as b

 

删除表数据:

delete from 表名;

truncate table 表名;

 

posted @ 2014-04-10 09:47  一个坟头  阅读(174)  评论(0编辑  收藏  举报