1.SELECT * FROM Table WHERE ID IN (3, 4, 5, 6, 11, 17) 2.SELECT * FROM Table LIMIT 10 另:MySQL中有类似sqlserver的自增字段吗?有
SELECT * FROM Table WHERE ID IN (3, 4, 5, 6, 11, 17) SELECT * FROM Table LIMIT 10没有问题!
可以下载一个mysql手册随时都可以翻翻。
SELECT * FROM Table WHERE ID IN (3, 4, 5, 6, 11, 17) SELECT * FROM Table LIMIT 10
这样也可以: 1.SELECT * FROM Table WHERE ID = 3 or ID = 4 or ID = 5 or ID = 6 or ID = 11 or ID = 17 不过这个有点傻 2.SELECT * FROM Table limit 0,10自增字段:auto_increment
2.SELECT * FROM Table LIMIT 10
另:MySQL中有类似sqlserver的自增字段吗?有
SELECT * FROM Table LIMIT 10没有问题!
SELECT * FROM Table LIMIT 10
1.SELECT * FROM Table WHERE ID = 3 or ID = 4 or ID = 5 or ID = 6 or ID = 11 or ID = 17 不过这个有点傻
2.SELECT * FROM Table limit 0,10自增字段:auto_increment
第二句的top在mysql中是limit
其实都是sql语句,都差不多