MySQL ±àÂë»úÖÆ
Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharacter_set_resultsÖÐÉ趨µÄ×Ö·û¼¯·¢Ë͸øÓû§¡£
DISCUZ²¢Ã»ÓÐʹÓÃset NAMES character
SET NAMES 'x'Óï¾äÓëÕâÈý¸öÓï¾äµÈ¼Û£º
mysql> SET character_set_client = x; mysql> SET character_set_results = x; mysql> SET character_set_connection = x;
¶øDISCUZÀïÃæÊÇ
¸´ÖÆ´úÂë
´úÂëÈçÏÂ:
@mysql_query("SET
character_set_connection=$dbcharset, character_set_results=$dbcharset,
character_set_client=binary", $this->link);
SET character_set_client = binary;ʹÓöþ½øÖÆ×Ö·û¼¯²éѯ
´ËÈý´¦µÄ×Ö·ûÉ趨ºÜ´ó³Ì¶ÈÉÏ»á½â¾öÂÒÂëÎÊÌ⣬ÄÇô×ÅÈý¸öÉ趨¾ßÌåÓÐʲô×÷ÓÃÄØ£¿
character_set_client
Ö¸
¶¨µÄÊÇSqlÓï¾äµÄ±àÂ룬Èç¹ûÉèÖÃΪ binary£¬mysql¾Íµ±¶þ½øÖÆÀ´´¦Àí£¬character_set_connectionÖ¸¶¨ÁËmysql
ÓÃÀ´ÔËÐÐsqlÓï¾äµÄʱºòʹÓõıàÂ룬Ҳ¾ÍÊÇ˵£¬³ÌÐò·¢Ë͸øMySQL
µÄSQLÓï¾ä,»áÊ×Ïȱ»MySQL´Ócharacter_set_clientÖ¸¶¨µÄ±àÂëת»»µ½character_set_connectionÖ¸¶¨µÄ
±àÂ룬Èç¹ûcharacter_set_clienÖ¸¶¨µÄÊÇbinary£¬ÔòMySQL¾Í»á°ÑSQLÓï¾ä°´ÕÕ
character_set_connectionÖ¸¶¨µÄ±àÂë½âÊÍÖ´ÐÐ.
µ±Ö´ÐÐSQLÓï¾äµÄ¹ý³ÌÖУ¬±ÈÈçÏòÊý¾Ý¿âÖвåÈë×ֶεÄʱºò£¬×Ö¶ÎÒ²ÓÐ
±àÂëÉèÖã¬Èç¹û×ֶεıàÂëÉèÖúÍcharacter_set_connectionÖ¸¶¨µÄ²»Í¬£¬ÔòMySQL
»á°Ñ²åÈëµÄÊý¾Ýת»»³É×Ö¶ÎÉ趨µÄ±àÂë¡£SQLÓï¾äÖеÄÌõ¼þÅжϺÍSQL²åÈëÓï¾äµÄÖ´Ðйý³ÌÀàËÆ.
µ±SQLÖ´ÐÐÍê±ÏÏñ¿Í»§¶Ë·µ»ØÊý¾ÝµÄʱºò£¬»á
°ÑÊý¾Ý´Ó×Ö¶ÎÖ¸¶¨µÄ±àÂëת»»Îªcharacter_set_resultsÖ¸¶¨µÄ±àÂ룬Èç¹ûcharacter_set_results=NULL
Ôò²»×öÈκÎת»»¶¯×÷£¬£¨×¢ÒâÕâÀïÉèÖÃΪNULL²»µÈÓÚûÓÐÉèÖã¬Ã»ÓÐÉèÖõÄʱºòMySQL»á¼Ì³ÐÈ«¾ÖÉèÖã©,
¹¤×÷ÖбȽÏÓÐÓõľÍÊÇÀûÓÃMySQL½øÐÐתÂë¡¢²»Í¬±àÂëµÄÊý¾Ý¿âÖ®¼ä¹²ÓÃÊý¾Ý¡£
Ïà¹ØÎĵµ£º
Ìí¼Ó×ֶεĸñʽ
ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name alter_specification [, alter_specification] ...alter_specification: table_option ... | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ]
eg.
ALTER TABLE myTbl ADD COLUMN newItem VARCHAR(20) DEFAULT "0" ......
1.½¨±íʱ¾Í´´½¨×ÔÔöÁУº
create table test
(
id int auto_increment primary key,
name varchar(20) not null,
password varchar(20) not null
);
insert into test values(null,'aa','aa');
insert into test values(null,'bb','bb');
×¢Ò⣺
²åÈëÓï¾äʱ£¬×Ô ......
1£º Can’t connect to [local] MySQL server´íÎó
Ò»¸öMySQL¿Í»§¿ÉÒÔÁ½ÖÖ²»Í¬µÄ·½Ê½Á¬½Ómysqld·þÎñÆ÷£ºUnixÌ×½Ó×Ö£¬Ëüͨ¹ýÔÚÎļþϵͳÖеÄÒ»¸öÎļþ(ȱʡ“/tmp /mysqld.sock”)½øÐÐÁ¬½Ó£»»òTCP/IP£¬Ëüͨ¹ýÒ»¸ö¶Ë¿ÚºÅÁ¬½Ó¡£UnixÌ×½Ó×Ö±ÈTCP/IP¸ü¿ì£¬µ«ÊÇÖ»ÓÐÓÃÔÚÁ¬½Óͬһ̨¼ÆËã»úÉϵķþÎñÆ÷¡£Èç¹ûÄ ......
½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ
ΪÁË×°mysql»·¾³²âÊÔ£¬×°ÉϺó·¢ÏÖÆô¶¯ºómysqlÕ¼ÓÃÁ˺ܴóµÄÐéÄâÄڴ棬´ï8°Ù¶àÕס£ÍøÉÏËÑË÷ÁËһϣ¬µÃµ½¸ßÈËÖ¸µãmy.ini¡£ÔÙҲû¼ûÔÙÏêϸµÄÁË..Ö»ºÃ´ò¿ªmy.iniÖðÐеĿУ¬ËäȻӢÎIJîÁ˵㣬²»¹ý¶àÉÙM»¹ÊÇ¿´µÃÃ÷µÄ^-^
¸ü¸ÄºóÈçÏ£º
innodb_buffer_pool_size=576M ->256M InnoDBÒýÇæ»º³å ......
phpºÍjavaͨÓÃsqlÓï¾ä·¨
SELECT max(id) from table
¸Ã·½·¨ÔÚ¶àÏ̵߳ÈÇé¿öÏ¿ÉÄÜ»áÔì³É²»ÕýÈ·¡£
javaÈýÖÖ·½·¨
1¡¢¸ù¾ÝpsµÄgetGeneratedKeys
PreparedStatement ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); //ºìÉ«Êǹؼü
ps.executeUpdate(); //Ö´Ðкó
ResultSet rs = ps.getGeneratedKeys ......