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

mysqlÁÙʱ±íµÄÎÊÌâ

ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á¢ÁÙʱ±í±ØÐëºÍÖ÷±íµÄ×Ö¶Îʲô¶¼Ò»Ñù£¬²ÅÄÜÆð×÷Óðɣ¿»¹ÓÐÀïÃæÖ÷±íµÄÊý¾Ý¿âÊDz»ÊÇÒ²¾Í¸´ÖƵ½ÁÙʱ±íÁË£¬Èç¹ûÎÒselect Ö÷±í£¬²»ÓÃÔÚдselect ÁÙʱÁ˰ɣ¬ÊÇ×Ô¶¯¾ÍselectµÄÁÙʱÁ˰É?
ÎÒÎÊÏ£¬ÊDz»Êǽ¨Á¢ÁÙʱ±í±ØÐëºÍÖ÷±íµÄ×Ö¶Îʲô¶¼Ò»Ñù£¬²ÅÄÜÆð×÷Óðɣ¿

ÄãÒª´ïµ½Ê²Ã´Ä¿µÄ

»¹ÓÐÀïÃæÖ÷±íµÄÊý¾Ý¿âÊDz»ÊÇÒ²¾Í¸´ÖƵ½ÁÙʱ±íÁË£¬Èç¹ûÎÒselect Ö÷±í£¬²»ÓÃÔÚдselect ÁÙʱÁ˰ɣ¬ÊÇ×Ô¶¯¾ÍselectµÄÁÙʱÁ˰É?

²»ÊÇ£¬³ý·ÇÄ㽫Êý¾ÝCOPYµ½ÁÙʱ±í

ûÓÐÃ÷°×ÄãµÄÒâ˼£¬Ïêϸ˵Ã÷ÎÊÌâ

ÒòΪÎÒÒ²ÊǸսӴ¥ÁÙʱ±í£¬ÖªµÀÔõô½¨Á¢£¬µ«²»ÖªµÀÔõôÓã¬Íû½â´ð£¡

CREATE TEMPORARY TABLE tt1 as select * from tt
¾ÍÊÇÓÐÊý¾ÝµÄ
Ö±½Ó
select * from tt1
²Ù×÷ÁÙʱ±í

CREATE TEMPORARY TABLE ....
ºÍÆÕͨ±íÓï·¨Ò»Ñù£¬¼ÓÉÏ TEMPORARY  ¹Ø¼ü×Ö¾ÍÐÐÁË¡£

ʹÓõÄʱºòºÍÆÕͨÓ÷¨Ò²Ò»Ñù¡£

µ«Ò»°ãÖ»ÓÐÒª´¦ÀíÊý¾ÝµÄʱºò²ÅʹÓá£ÄãµÄÄ¿µÄÊÇʲô£¿


OKÃ÷°×ÁË£¬Ð»Ð»£¬½áÌù¸ø·Ö£¡£¡

µ±Äڴ滺³åÇø²»¹»´óµÄʱºò ²éѯµÄʱ¼äÓпÉÄÜдÈëµ½ÁÙʱ±í½øÐйÜÀí


½¨Á¢ÁÙʱ±íÓëÆÕͨ±íÃ»Ê²Ã´Çø±ð
Ö»ÊǶàÁ˸ö¹Ø¼ü×Ö"temporary"°ÕÀ²


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MySQLË÷ÒýÎÊÌâ

ÏÖÔÚ×ö¶«Î÷ÒªMySQL£¬Ï£Íû´ó¼Ò½²Ò»ÏÂMySQLÖ§³ÖÄÄЩË÷Òý£¬¶øÇÒʲôʱºò½¨Ê²Ã´Ë÷Òý£¬ÒÔ¼°½¨Á¢ÔÚÄÄЩ×Ö¶ÎÉÏ£¬Ï£Íû¸ßÊÖÀÏÄñ´Í½Ì¡£¡£
×îºÃÊÇ×Ô¼ºÁìÎòµÄµÃ³öµÄ½áÂÛ×îºÃ¡£¡£
Thanks
ºÜ¸´ÔÓµÄÎÊÌ⣬һ°ãÔÚ²éѯ¡¢Á¬½ÓÉ ......

mysql Ææ¹ÖµÄ´íÎó

½ñÌì¸ã PHP ¿ª·¢µÄʱºò£¬¸ã³öÁËÕâ¸ö´íÎó£º

ÎÒÖ´ÐеÄÓï¾äÊÇ£º

INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES (98,'test','test','test');
......

Ë­ÓÐMySQL°²×°°ü£¿

Ë­ÓÐMySQL°²×°°ü£¿·¢¸øÎÒ¸öÍøÖ·...
http://dev.mysql.com/downloads/

http://dev.mysql.com/downloads/mysql/5.1.html

¹Ù·½ÏÂÔØµØÖ·¡£

ÎÒ²»¶®¿´Ó¢ÎÄßÖ

²»Óÿ´¶®£¬ÄãÖ±½ÓÕÒÄãÒªµÄ°æ±¾¾ÍÐÐÁË¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ