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

ÕÐmysql¼æÖ°½²Ê¦

±¾µ¥Î»³¤ÆÚÕÐmysqlµÈ¸÷ÀàÈí¼þ¼æÖ°½²Ê¦£¬ÈÕнǧԪ£¬¿ÉÖÜÄ©£¬ÈçÄúÏëÕõµãÍâ¿é£¬»ýÀÛ×ÊÔ´£¬³äʵÉú»î£¬ÇëÁªÏµÎÒ,ÒªÇóÓÐʵ¼ÊÏîÄ¿¾­Àú£¬Á½ÄêÒÔÉϹ¤×÷ʱ¼ä£¬±í´ïÄÜÁ¦½ÏºÃ£¬QQ496397940£¬Óʼþhailang869@163.com¡£


·¹ý

Õâ¸öºÃ

¶¥

ÒýÓÃ
±¾µ¥Î»³¤ÆÚÕÐmysqlµÈ¸÷ÀàÈí¼þ¼æÖ°½²Ê¦£¬ÈÕнǧԪ£¬¿ÉÖÜÄ©£¬ÈçÄúÏëÕõµãÍâ¿é£¬»ýÀÛ×ÊÔ´£¬³äʵÉú»î£¬ÇëÁªÏµÎÒ,ÒªÇóÓÐʵ¼ÊÏîÄ¿¾­Àú£¬Á½ÄêÒÔÉϹ¤×÷ʱ¼ä£¬±í´ïÄÜÁ¦½ÏºÃ£¬QQ496397940£¬Óʼþhailang869@163.com¡£

up

ÈôÊÇSQL SERVER£¬Å¼ÀÖÒâÊÔÏÂ

.


Ïà¹ØÎÊ´ð£º

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ