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

mysqlÖеĺº×ÖÎÊÌ⣿£¿£¿£¿

´ó¼ÒºÃ£º
    ÎÒ×î½üÔÚ¸ãÓÃCÁ¬½ÓMYSQL£¬ÔÚVCÏ£¬ÎÒÓÃINSERT²åÈëÓï¾ä£¬¾Í±¨Ò»¸ö´íÎó£¬ÎÒGOOGLEÁËһϣ¬ËµÊÇʲô²»ºº×ÖÎÊÌ⣬µ«´ó¶àÊý¶¼ÊÇÓëPHPµÄÎÊÌ⣬ҲûÓн²Ò»Ð©ÓëCµÄÓ÷¨£¬ÄÄλ¸ßÊÖÄܰïÎÒһϣ¬Ð»Ð»£¿£¿£¿
±¨Ê²Ã´´íÎóÒ²²»Ìù³öÀ´Ñ½

ÎÒ³öÏֵĴíÎóÊÇ£º
  Incorrect string value: '\xc2\xde' for columu 'name' at row 1

Ò²¾ÍÊÇÎÒÔÚnameÖвåÈëÁ˺º×Ö¡£¡£¡£

²»»áMYSQL

²»¶®MYSQL²»¶®C

Â¥Ö÷½áÌùÂÊÉõµÍ£¬ÎÒÒ²²»¹ÜÁË

°²×°mysqlµÄʱºòÑ¡GB2312ÁËû


okÁË¡£


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿

ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿



½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö

ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ