Mysql´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÔÚMysqlÖж¼ÊÇÉèÖÃΪ gb2312µÄ£¬ÔÚEditorÒ²¿ÉÒ²²åÈëÖÐÎÄ£¬µ«ÊÇÔÚJavaÖвåÈëÖÐÎÄÊÇ×ÜÊÇÂÒÂ룬¶øÇÒServletÖÐÒ²ÊÇ response.setCharactorEncoding("gb2312");µÄ£¬Êä³öµ½¿ØÖÆÌ¨ÖеÄÒ²ÊÇÖÐÎÄ£¬µ«ÎªÊ²Ã´²åÈëµ½Êý¾Ý¿âÖеÄÈ«ÊÇÂÒÂ룿
show variables like 'char%'; Ìù½á¹û Á¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312 ÊÔÊÔ¿´ ²Î¿¼ÏÂÌù¡£Ó¦¸ÃÊÇÄãÔÚJAVA³ÌÐòÖеÄ×Ö·û¼¯ÉèÖÃÎÊÌâ¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ì«¸ÐлÁË£¬¹ûÈ»ÔÚÁ¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312¾Í¿ÉÒÔÁË£¬µ«ÊÇ ÎÒ»¹ÏëÎÊ£¬ÎªÊ²÷á:String test=new String(test.getBytes("gb2312")); ÕâÑù×ÓÔÚjavaÖÐתһ´Îºó£¬Ö±½Ó·ÅÈëÊý¾Ý¿âÈ´²»ÐÐÄØ£¿È´Ò»¶¨ÒªÔÚºóÃæ¼ÓÉϸögb2312ÄØ£¿ÒýÓà ̫¸ÐлÁË£¬¹ûÈ»ÔÚÁ¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312¾Í¿ÉÒÔÁË£¬µ«ÊÇ ÎÒ»¹ÏëÎÊ£¬ÎªÊ²÷á:String test=new String(test.getBytes("gb2312")); ÕâÑù×ÓÔÚjavaÖÐתһ´Îºó£¬Ö±½Ó·ÅÈëÊý¾Ý¿âÈ´²»ÐÐÄØ£¿È´Ò»¶¨ÒªÔÚºóÃæ¼ÓÉϸögb2312ÄØ£¿ ÀǵÄÎÄÕ½âÊ͵ĺÜÇå³þ£¬È¥¿´¿´¡£mysqlµÄ×Ö·û¼¯×öµÄºÜϸ£¬Ã¿¸öµØ·½¶¼Òª×¢Òâͳһ¡£
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÇëÎÊ Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£» ·þÎñÆ÷Ãû£º Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿ ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡ Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿ ÒýÓà ÇëÎÊ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......