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"°ÕÀ²
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃDELET from WHERE NAME IS NULL »ò=¡®¡¯
¶¼²»Ðа¡
ÄDz»¿ÉÄܲ»Êǿգ¬ÊÇÆäËû×Ö·û
Êǿհ¡£¬Ã»´í°¡¡£
SQL code:
DELET from WHERE NAME IS NULL or LEN(NAME)=0 or UPPER(NAME)='NULL'
ÒýÓÃ
S ......
ÏÖÔÚ×ö¶«Î÷ÒªMySQL£¬Ï£Íû´ó¼Ò½²Ò»ÏÂMySQLÖ§³ÖÄÄЩË÷Òý£¬¶øÇÒʲôʱºò½¨Ê²Ã´Ë÷Òý£¬ÒÔ¼°½¨Á¢ÔÚÄÄЩ×Ö¶ÎÉÏ£¬Ï£Íû¸ßÊÖÀÏÄñ´Í½Ì¡£¡£
×îºÃÊÇ×Ô¼ºÁìÎòµÄµÃ³öµÄ½áÂÛ×îºÃ¡£¡£
Thanks
ºÜ¸´ÔÓµÄÎÊÌ⣬һ°ãÔÚ²éѯ¡¢Á¬½ÓÉ ......
½ñÌì¸ã PHP ¿ª·¢µÄʱºò£¬¸ã³öÁËÕâ¸ö´íÎó£º
ÎÒÖ´ÐеÄÓï¾äÊÇ£º
INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES (98,'test','test','test');
......