sql 高手请指点这样的select 如何写,要求见贴内,先谢过! 1、select * from a limit 0,92、select top(10) from a order by id desc3、select * from a limit 9,19 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE TABLE sort ('Col1' INT (3) UNSIGNED NOT NULL, 'Col2' CHAR (1) NOT NULL, PRIMARY KEY (Col1),INDEX Col2 (Col2));INSERT INTO sort (Col1, Col2) VALUES (1, 'A');INSERT INTO sort (Col1, Col2) VALUES (2, 'C');INSERT INTO sort (Col1, Col2) VALUES (3, 'B');INSERT INTO sort (Col1, Col2) VALUES (4, 'D');INSERT INTO sort (Col1, Col2) VALUES (5, 'F');INSERT INTO sort (Col1, Col2) VALUES (6, 'E');INSERT INTO sort (Col1, Col2) VALUES (7, 'H');INSERT INTO sort (Col1, Col2) VALUES (8, 'G');INSERT INTO sort (Col1, Col2) VALUES (9, 'K');INSERT INTO sort (Col1, Col2) VALUES (10, 'J');INSERT INTO sort (Col1, Col2) VALUES (11, 'L')INSERT INTO sort (Col1, Col2) VALUES (12, 'I');INSERT INTO sort (Col1, Col2) VALUES (13, 'N');INSERT INTO sort (Col1, Col2) VALUES (14, 'M');SELECT * FROM Table1 Limit 0,10;#按物理顺序取前10个SELECT * FROM Table1 Limit 10,10;#按物理顺序从第10开始取10个取后几个,要先查询了总记录数SELECT Count(*) As Count FROM Table1;然后在自己程序里处理成如上所示的SQL至于按物理顺序逆序取,呵呵,:《 $sql = "select cardid,company,name from namecard where";......$sql .= " limit $offset,10";$result2 = mysql_query($sql); while ($row = mysql_fetch_array($result2)) { show_card($row); } $pages = ceil($num/10); echo "<tr bgcolor=#ffffff><td align=center colspan=5>"; echo "(共{$pages}页)\n\n\n"; if($offset>=10) //$offset大于9,在第二页面以上就会显示前一页 { $preoffset = $offset-10; echo "<a href=\"$PHP_SELF?status=$status&offset=$preoffset\">前一页</a> \n"; } for ($i=1; $i <= $pages; $i++) { $newoffset=10*($i-1); echo "<a href=\"$PHP_SELF?status=$status&offset=$newoffset\">[$i]</a> \n"; } if ($pages!=0 && ($offset/10+1)<$pages) { echo "<a href=\"$PHP_SELF?status=$status&offset=".($offset+10)."\">下一页</a> \n"; } echo "</td></tr></table>"; } mysql中对游标结果进行循环处理无结果输出 mysql 有没有事务级临时表啊。 jsp+mysql 谁有类似淘宝的数据库吗 在线急等,如何从数据库中直接取出最小值? MYSQL 如果進行開發界面 有什么办法,可以在WINXP上把LINUX里的MYSQL数据库完全备份到WINXP机器??或者是导出到WINXP机器? 你好:请问听说与MySQL同一个城市的还有另一个数据库Mimer SQL?能给全面的对比一下吗? 如何使两台MYSQL共享一个数据库 MySQL在MyBatis下的输出问题 MySQL和Postgresql,孰优孰劣? 问个蠢问题,Mysql是不是没有相当于 布尔型 的类型啊?
INSERT INTO sort (Col1, Col2) VALUES (1, 'A');
INSERT INTO sort (Col1, Col2) VALUES (2, 'C');
INSERT INTO sort (Col1, Col2) VALUES (3, 'B');
INSERT INTO sort (Col1, Col2) VALUES (4, 'D');
INSERT INTO sort (Col1, Col2) VALUES (5, 'F');
INSERT INTO sort (Col1, Col2) VALUES (6, 'E');
INSERT INTO sort (Col1, Col2) VALUES (7, 'H');
INSERT INTO sort (Col1, Col2) VALUES (8, 'G');
INSERT INTO sort (Col1, Col2) VALUES (9, 'K');
INSERT INTO sort (Col1, Col2) VALUES (10, 'J');
INSERT INTO sort (Col1, Col2) VALUES (11, 'L')
INSERT INTO sort (Col1, Col2) VALUES (12, 'I');
INSERT INTO sort (Col1, Col2) VALUES (13, 'N');
INSERT INTO sort (Col1, Col2) VALUES (14, 'M');SELECT * FROM Table1 Limit 0,10;
#按物理顺序取前10个SELECT * FROM Table1 Limit 10,10;
#按物理顺序从第10开始取10个
取后几个,要先查询了总记录数
SELECT Count(*) As Count FROM Table1;
然后在自己程序里处理成如上所示的SQL至于按物理顺序逆序取,
呵呵,
:《
......$sql .= " limit $offset,10";
$result2 = mysql_query($sql);
while ($row = mysql_fetch_array($result2)) {
show_card($row);
}
$pages = ceil($num/10);
echo "<tr bgcolor=#ffffff><td align=center colspan=5>";
echo "(共{$pages}页)\n\n\n";
if($offset>=10) //$offset大于9,在第二页面以上就会显示前一页
{
$preoffset = $offset-10;
echo "<a href=\"$PHP_SELF?status=$status&offset=$preoffset\">前一页</a> \n";
} for ($i=1; $i <= $pages; $i++)
{
$newoffset=10*($i-1);
echo "<a href=\"$PHP_SELF?status=$status&offset=$newoffset\">[$i]</a> \n"; }
if ($pages!=0 && ($offset/10+1)<$pages)
{
echo "<a href=\"$PHP_SELF?status=$status&offset=".($offset+10)."\">下一页</a> \n";
}
echo "</td></tr></table>"; }