Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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;
+----------+


Ïà¹ØÎĵµ£º

ÓÅ»¯MySQLÊý¾Ý¿â²éѯ

ÓÅ»¯MySQLÊý¾Ý¿â²éѯ
 
   ÔÚÓÅ»¯²éѯÖУ¬Êý¾Ý¿âÓ¦ÓÃ(ÈçMySQL)¼´Òâζ×ŶԹ¤¾ßµÄ²Ù×÷ÓëʹÓá£Ê¹ÓÃË÷Òý¡¢Ê¹ÓÃEXPLAIN·ÖÎö²éѯÒÔ¼°µ÷ÕûMySQLµÄÄÚ²¿ÅäÖÿɴﵽÓÅ»¯²éѯµÄÄ¿µÄ
¡¡¡¡ÈκÎһλÊý¾Ý¿â³ÌÐòÔ±¶¼»áÓÐÕâÑùµÄÌå»á£º¸ßͨÐÅÁ¿µÄÊý¾Ý¿âÇý¶¯³ÌÐòÖУ¬Ò»ÌõÔã¸âµÄSQL²éѯÓï¾ä¿É¶ÔÕû¸öÓ¦ÓóÌÐòµÄÔËÐвúÉúÑÏÖØµÄ ......

MySQLµÄ¿ªÔ´Èȱ¸·Ý¹¤¾ßXtrabackup1.2

InnoDB,ÆÕͨµÄmysql
dump±¸·ÝÏÂÀ´,mysql»Ö¸´ÆðÀ´ÂýµÃÒª
ËÀ.
ÓÚÊÇÍøÉÏÕÒÁ˺þÃ,²ÅÕÒµ½Õâô¸ö¹¤¾ß
.
http://launchpad.net/percona-xtrabackup/release-1.2/release-1.2/+download/xtrabackup-1.2.tar.gz
ÏȲâÊÔÏÂÔÙ˵.
¿ÉÒÔÕâô±¸·Ý:
MyISAM
񡜧
/usr/local/mysql/bin/mysqldump -uyejr -pyejr
--default-char ......

JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì

JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì
¹¤³ÌÊÓͼ£º
´úÂëÇåµ¥£º
myconn.java
package org.apache.sh_mysql.test;
import java.sql.*;
public class MyConn {

private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost/test?useUnicode=true&characterEn ......

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......

hibernate mysql ´æ´¢¶þ½øÖÆÎļþÎÊÌâ×ܽá

ÏÈ˵Ã÷Ò»ÏÂBlobµÄÀàÐÍ£¬Ö±½Ó´ÓÍøÉÏÕª³­ÁË£¡£¡£¡
1¡¢MySQLÓÐËÄÖÖBLOBÀàÐÍ:
¡¡¡¡·tinyblob:½ö255¸ö×Ö·û
¡¡¡¡·blob:×î´óÏÞÖÆµ½65K×Ö½Ú
¡¡¡¡·mediumblob:ÏÞÖÆµ½16M×Ö½Ú
¡¡¡¡·longblob:¿É´ï4GB
2¡¢³ýÁËÀàÐͶԺóÃæ´æÈ¡Îļþ´óСÓÐÏÞÖÆ£¬»¹ÒªÐÞ¸ÄmysqlµÄÅäÖÃÎļþ¡£
¡¡¡¡Windows¡¢linux»ù±¾Ò»Ñù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ