MySQLÖÐÊý¾Ý½á¹û¼¯·ÖÒ³¹¦ÄܵÄʵÏÖ·½·¨
---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º MySQL ·ÖÒ³ limit
----------------------------------------------------------------------------
Ä¿Ç°B/S¼Ü¹¹µÄÈí¼þ´óÐÐÆäµÀ¡£Í¨¹ýä¯ÀÀÆ÷ÈçºÎÏòÖÕ¶ËÓû§Ö»Õ¹Ê¾Ö¸¶¨Ò³ÃæÄÚÈݶø²»ÊÇÈ«²¿µÄ£¿±Ï¾¹·µ»ØÈ«²¿½á¹û¼¯£¬Ê±¼äºÍ¿Õ¼ä¿ªÏú¶¼ºÜ´ó¡£
Èç´ËÇé¿öÏ£¬¶ÔSQL·µ»Ø½á¹û¼¯½øÐзÖÒ³ÊǸöºÜ²»´íµÄ½â¾ö·½°¸¡£
±¾ÎÄÖ÷Òª½éÉÜMySQLÊý¾Ý¿âÖеķÖҳʵÏÖ·½Ê½¡£ÎÒÒÔÒ»¸öÊý¾Ý¿â¹ÜÀíÔ±µÄ½Ç¶È½øÐÐ˵Ã÷£¬ÖÁÓÚ¾ßÌåµÄʵÏÖ»¹ÐèÒª¿ª·¢ÈËÔ±Ïêϸ±àд¹ý³Ì¡£
×ܵÄ˵À´£¬ÔÚMySQLÖÐʵÏÖ·ÖÒ³¹¦ÄÜÊǺܼòµ¥µÄÊÂÇé¡£MySQLÊý¾Ý¿âµÄ¿ª·¢ÈËÔ±Ìæ¹ã´óµÄʹÓÃÕß×ÅÏ룬ÌṩÁËÒ»¸ö¹Ø¼ü×ÖlimitÀ´ÊµÏÖÏÞ¶¨Ö¸¶¨·¶Î§µÄ¹¦ÄÜ¡£
ÏÂÃæ¼òµ¥½éÉÜ·ÖÒ³µÄ˼·¡£
ÔÚMySQL5.0.15-nt-maxϽøÐвâÊÔ¡£
1.н¨Ò»ÕÅÁÙʱ±í(MyISAM»òÕßInnoDBÀàÐ͵Ķ¼¿ÉÒÔ)£¬±¾²âÊÔ±íûÓÐʹÓÃ×ÔÔöÁС£
CREATE TABLE `andkylee` (
`id` int(11) NOT NULL,
`name` varchar(30) default NULL,
`sex` char(1) NOT NULL,
`age` smallint(6) default NULL,
`note` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2.²åÈë²âÊÔÊý¾Ý¡£ ÔÚÕâÀïÓÈÆä½éÉÜÒ»ÖÖ²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ·½·¨¡£
ÏȲåÈë2ÌõÊý¾Ý£¬
insert into andkylee
values(1,'hanyuliu','F',25,'aaaaaaaaaa'),(2,'andkylee','F',33,'bbbbbbbbbb');
ÅúÁ¿²åÈëÊý¾Ý
ÔÚûÓÐ×ÔÔöÁеÄÇé¿öÏ£¬ÓÃÏÂÃæµÄÓï¾äÀ´ÊµÏÖ²åÈë“Öظ´”Êý¾Ý¡£
insert into andkylee
select id+(select max(id) from andkylee),name,sex,age,note from andkylee;
±¾Óï¾äÄܹ»¸´ÖƱíÒÑÓеÄËùÓмǼ£¬²¢ÇÒÄܹ»ÊµÏÖ“Ö÷¼üÁД×ÔÔö¡£
¿ÉÄÜÓеãȱÏݵÄÊÇ£ºÐèÒªÔÙselectÁбíÖÐÖð¸öд³ö¸÷¸öÁÐÃû¡£µ«ÊÇ£¬ºÃÏñº¬ÓÐ×ÔÔöÁеıíΪÁËʵÏÖ²åÈëÖظ´Êý¾Ý£¬Ò²±ØÐë°Ñ·Ç×ÔÔöÁж¼Ð´³öÀ´°É¡£ Èç¹ûÎÒ˵µÄ²»¶Ô£¬Çë¸æÖª¡£
Ñ»·²åÈëÖظ´Êý¾Ý£¬Ê¹µÃ±íÊý¾ÝÐÐÊýÒÔÖ¸Êý·½Ê½Ôö³¤¡£ ÔÙ°ÑÒÑÓеÄÊý¾Ý²åÈëµ½±íÄÚ£¬ÐÐÊý±äΪÒÔÇ°µÄ2±¶¡£
insert into andkylee
select id+(select max(id) from andkylee),name,sex,age,note from andkylee;
mysql> select count(*) from andkylee;
+----------+
Ïà¹ØÎĵµ£º
ǰ׺Ë÷Òý
(1)Èç¹ûÒÔ¶à¸ö×Ö¶Î×÷ΪË÷Òý£¨a,b£¬c)×÷Ϊһ¸ökey,ÔÚ²éѯʱ·Ö¸ù¾ÝÆ¥ÅäÇé¿öÊÇ·ñʹÓÃË÷Òý£¬ËùÒÔ£¬a/ a,b/ a,b,cÕâÑùµÄ²éѯ¶¼ÄÜʹÓõ½£¬µ«ÊÇb,a/a,c/c,aµÈ²»·û֪ǰ׺ƥÅä¾Í²»ÄÜʹÓã¬ËùÒÔÔÚдsqlʱÐèҪעÒâ
(2)¶ÔÓںܳ¤µÄ×Ö·û´®ÐèÒªÉú³Ékeyʱ£¬¿ÉÒÔÕÒ³ö×ʹÓõÄ×Ö·û´®µÄ×î³£¼ûǰ׺(Ç°N¸ö×ÖÌõ×÷Ϊkey,¶ø²»Êǽ ......
×î½üдÁËÒ»¸ö¼òµ¥µÄMysql²Ù×÷À࣬ÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬»¹Çë¸÷λ¸ßÊÖÖ¸ÕýÒ»ÏÂÎö¹¹º¯ÊýµÄÓ÷¨£º
<?php
/*
* Created on 2010-5-25
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*
* class mysql
* made by S71ENCE
*/
class mysql ......
×¼±¸:
lighttpd-1.4.15.tar.gz
php-4.4.2.tar.gz
mysql-5.0.20a.tar.gz
¿ªÊ¼:
1 ±àÒë°²×°lighttpd
# tar zxvf lighttpd-1.4.15.tar.gz
# cd lighttpd-1.4.15
# ls
# ./configure --prefix=/usr/local/lighttpd //´Ë²¿ÎÞ·¨±àÒëʱÌáʾ°²×°prce-devel
#&nbs ......
phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall to undefined function 'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost]# mysql -u root -p
Enter password:
ERROR 2002 (H ......