摘要：\s 查看mysql的字符集 把server characterset和db characterset修改成utf8 在my.ini的mysqld下面添加两行代码，重启mysql [mysql] default-character-set=utf8 [mysqld] character-set-se 阅读全文

摘要：第一种方法： select (@i:=@i+1) as i,table_name.* from table_name,(select @i:=0) as it 第二种方法： set @rownum=0;select @rownum:=@rownum+1 as rownum, t.username f 阅读全文