mysql 1366´íÎ󣬱£´æÖÐÎĵķ½·¨
³õѧmysqlÎÒÒ²Åöµ½ÖÐÎÄ´æ´¢µÄÎÊÌ⣬ÒÔÏÂÊÇÎҵĽâ¾ö·½°¸£º
1.Ê×ÏÈÔÚ×Ö¶ÎÑ¡Ïîcolumn option Öн«×Ö¶Î×Ö·û¼¯column charsetÉèΪgb2312¡£
2.»¹ÐèÒªÔÚ±íÑ¡Ïîtable option ÖÐͬÑù½«charsetÉèÖÃΪgb2312.
3.×îºóÈç¹û»¹²»ÐУ¬¾ÍÔÚmysql°²×°Ä¿Â¼ÏÂÕÒµ½my.ini,ÕÒµ½ÒÔÏÂλÖãº
[mysql]
default-character-set=gb2312
ͬÑù½«character-setÉèΪgb2312.
¾¹ýÒÔÉÏÉèÖþͿÉÒÔÔÚmysqlÖб£´æÖÐÎÄÁË¡£
Ïà¹ØÎĵµ£º
mysql µ¼³ö±í£º
mysqldump -u Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû ±íÃû
> ±íÃû.sql
mysql µ¼³öÊý¾Ý¿â£º
mysqldump -u
Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû
>
Êý¾Ý¿â
Ãû.sql
mysql µ¼Èë±í£º
>source e:\base\pet.sql;
mysql µ¼Èë±íÊý¾Ý£º
>LOAD DATA LOCAL INFILE 'e:path/pet.txt ......
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
Òª²»³öÏÖÂÒÂ룬¾ÍÒª±£³ÖÊý¾Ý¿âºÍÒ³ÃæµÄ±àÂë¸ñʽһÖÂ.ÎÒÈ«²¿Ê¹ÓÃutf-8µÄ±àÂë.
Ê×ÏÈÒ³Ãæ:
1. ½«ÎļþÓÃUE´ò¿ª,½«ÎļþÁí´æΪUTF-8ÎÞBOM¸ñʽ.ºÜ¶à±à¼Æ÷¶¼¿ÉÓÃ.
2.ʹÓà header("content-type:text/html;¡¡charset=utf-8"); Ç¿ÖÆת»»³Éutf-8µÄ±àÂë.
Ò²¿ÉÒÔн¨Ò»¸öhead.php,ÈçÏÂ,ÔÚÒ³ÃæÖÐÓÃinclude( ......
ÏÔʾËùÓÐÊý¾Ý¿â show databases;
´´½¨Êý¾Ý¿â create dababase stu;
ɾ³ýÊý¾Ý¿âdrop database stu;
Çл»µ½Êý¾Ý¿âuse stu;
È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
-> stu_id int(8) ......