摘要：REPLACE INTO users(id,username,birthday,sex,address) VALUES(25,'tom','2011-11-11',2,'杭州'),(26,'李四','2010-10-10',1,'石家庄');INSERT INTO users(id,username 阅读全文

摘要：mysql> select * from (select @n:=@n+1 as n, a.* from (select * from result order by subjectno,studentresult desc)a,(select @n:=0)b)c where c.n%18<6 an 阅读全文