mysqlÂÒÂëÎÊÌâ
ÎÒÓÃjavaÔÚ£í£ù£ó£ñ£ìÖвåÈëÊý¾ÝΪʲô×ÜÊÇÂÒÂë
³ÌÐòÖбàÂëÊÇ£ç£â£ëµÄ£¬¶øÇҵõ½µÄÒ²ÊÇÕý³£µÄ£¬µ«ÎÒ²åÈëÊý¾Ý¿â¾ÍÊÇÂÒÂ룬
Êý¾Ý¿âµÄ±àÂëÒ²ÊÇ£ç£â£ëµÄ
ÎÒ¶¼ÓôÃÆÁË£¬ÐÖµÜÃǰïæ½â¾öÏÂÁË
ÔÚ²åÈëÊý¾ÝǰִÐÐ
set names gbk; ÊÔһϡ£
²»ÐÐѽ£¬¸çÃÇ
²åÈëµÄÊý¾ÝÊÇÂÒÂë
ÄãÊÇ´Ómysql¿ØÖÆÌ¨¿´µ½µÄÂÒÂ뻹ÊdzÌÐòÖÐÊÇÂÒÂë?
ÎÒÓôúÂëµÃµ½µÄÊÇÕý³£µÄ£¬µ«²åÈëµ½Êý¾Ý¿â¾ÍÊÇÂÒÂ룬Ӧ¸ÃÊÇÊý¾Ý¿âµÄÎÊÌâ
µ«ÎÒµÄÊý¾Ý¿âµÄ±àÂëÒ²ÊÇ£ç£â£ëµÄ£¬£÷£è£ù£¿
ÄúµÄ´úÂëµÃµ½µÄÕý³£,²åÈëµ½×ÊÁÏ¿âÊÇÂÒÂë->Äú´ÓÄÄÀï¿´¼ûÊÇÂÒÂëµÄÄØ??ʲô¿Í»§¶ËÄØ?Ôõô¿´¼ûµÄÄØ?
ÎÒÖ´ÐУó£ñ£ìÓï¾ä֮ǰÔÚ¿ØÖÆÌ¨Êä³öÊÇÕý³£µÄ£¬µ«Ö´ÐУó£ñ£ìÓï¾ä²åÈëµ½Êý¾Ý¿â¾ÍÊÇÂÒÂë
Ö´ÐУó£ñ£ìÓï¾ä²åÈëµ½Êý¾Ý¿â
ÊÇÔÚÄÄÀïÖ´Ðа¡?
ÔÚ³ÌÐò´úÂëµÄ·ÃÎÊÊý¾Ý¿â²ãѽ
¶øÇÒ£¬ÎÒÒÔǰÓÃ×ÅûÎÊÌâµÄ£¬ºóÀ´ÎÒÎÞÒâ°ÑÊý¾Ý¿âɾÁË£¬
ÎÒÓÖÖØÐ½¨Á˸öÊý¾Ý¿â£¨ÓÃphpmyadmin¹¤¾ß£©£¬¾Í³öÏÖÂÒÂëÎÊÌâÁË
ÎÒ°²×°µÄÊý¾Ý¿âÊDz»ÊÇÓÐÎÊÌâ
ÔÚ¿ØÖÆÌ¨Ö´ÐÐshow variables like 'character_set%'Ìù½á¹û³öÀ´¿´¿´¡£
Ö´ÐеĽá¹ûÊÇ£º
character_set_client | latin1
character_set_connection | latin1
character_set_database | utf8
character_set_filessystem | binary
character_set_results | latin1
character_set_server | latin1
character_set_syst
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿
ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö
ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......