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主键(id)的值为自增 mysql如何取得筛选出的10条数据的最大id 编号很多,如何查询某一条编号的最后一条记录 小妹请教两个表,表连接的写法。 新手学Mysql ,高手指教 MYSql插入语句如何实现某字段值等于ID值(ID值是自动增加) mysql_query问题! 那位仁兄能帮我解决问题!!!!?(关于PHP和MYSQL) 100分求助PHP连MYSQL的奇怪问题之解答 数据库拒绝访问 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>"; }