mysql³£ÓÃÃüÁî
1¡¢mysqlÊý¾Ý¿âÓÐÁ½ÖÖÇý¶¯£º
MySQL Connector/J Driver¡¢MMMysql driver¡£
2¡¢µ¼Èëµ¼³öÊý¾Ý¿âÃüÁ£¨binĿ¼Ï£©
µ¼³ö£ºmysqldump -u root -p bokele >c:/mysql.sql --default-character-set=gbk
µ¼È룺C:\mysql\bin\> mysql -u root -p
˵Ã÷£ºC:\mysql\bin\±íʾ½øÈëmysql³ÌÐò¸ùĿ¼
C:\helloapp\schema\sampledb.sqlÊÇÒªµ¼ÈëÊý¾Ý¿âµÄÎļþµÄλÖÃ
c:/mysql.sqlÊǵ¼³öµÄsqlÎļþ
--default-character-set=gbk Ö¸±àÂ뷽ʽ
3¡¢ÐÞ¸Äroot¿ÚÁ£¨binĿ¼Ï£©
bin>mysql -u root -p
mysql>set password for root@localhost=password('123');
˵Ã÷£º½«rootµÄ¿ÚÁîÉèÖÃΪ123
4¡¢Æô¶¯Í£Ö¹mysql¿Í»§³ÌÐò£¨binĿ¼Ï£©
1£©mysql -u root -p
2£©£¨ÊäÈëÃÜÂ룩
3£©create database SAMPLEDB
4£©user SAMPLE
5£©£¨¸÷ÖÖsql²Ù×÷£©
6£©exit£¨Í˳ö£©
5¡¢Æô¶¯ºÍÍ£Ö¹mysql·þÎñ£¨ÃüÁîÐÐÏ£©
Æô¶¯£ºnet start mysql Í£Ö¹£ºnet stop mysql
6¡¢×¢²áºÍɾ³ýmysql·þÎñ£¨binĿ¼Ï£©
×¢²á£ºmysqld-nt --install ɾ³ý£ºmysqld-nt --remove
7¡¢µ¼ÈëmysqlÊý¾Ý¿âʱ³öÏÖ£ºData too long for column '***' at row *£¬
ÃèÊö£ºmysqlÓÃUTF8×Ö·û¼¯£¬±¸·ÝÎļþ£¨***.sql£©ÊÇgbk¸ñʽµÄ£¬ÔËÐÐC:\mysql\bin\> mysql -u root -p
·ÖÎö£ºÒòΪmysqlÓÃutf8±àÂ룬ËùÒÔÒ»¸ö×Ö½ÚÕ¼24루UTF8×Ö·ûÊǿɱ䳤¶È£¬Ó¢ÎÄ8룬ÖÐÎÄ24λ£¬ÎªÂú×ãÈ«ÊÇÖÐÎÄÇé¿ö£¬ÓÃ24λ±íʾ£©£¬µ«mysqlµÄvarcharÀàÐÍÓÐ×î´ó³¤¶È£¬¶ø255×24¿ÉÄܳ¬¹ý×î´ó³¤¶È£¬ËùÒÔ±¨´í¡£¿É¼ûÔ±¸·ÝÎļþ½¨Êý¾Ý¿âʱӦ¸ÃʹÓõIJ»ÊÇUTF8£¬¶øÓ¦ÎªÒ»¸ö×Ö·ûÕ¼8λµÄlatin1±àÂ뷽ʽ£¬ÕÒµ½ÎÊÌâ´ð°¸¡£
½â¾ö£ºÔÚ½¨±íÎļþ¶¥¶Ë¼ÓÈëÒÔÏÂÓï¾ä£º
drop database if exists Web;//WebΪҪ½¨µÄÊý¾Ý¿â
create database Web default charset=latin1 ;
use Web;
set charset latin1;
7. ÅäÖÃ×Ö·û¼¯
½¨¿âʱÅäÖÃ×Ö·û¼¯
create database testxxx default charset=utf8
½¨±íʱÅäÖÃ×Ö·û¼¯
CREATE TABLE `t_agent` (
`ID` smallint(5) NOT NULL
) DEFAULT CHARSET=utf8 ;
ÐÞ¸Ä×Ö·û¼¯
Windowsƽ̨
windowsϵÄmysqlÅäÖÃÎļþÊÇmy.ini,Ò»°ãÔÚc:\windows\my.ini»òÕßc:\winnt\my.ini¿ÉÒÔÖ±½ÓÔÚÕâ¸öÎļþÀïÃæ¼ÓÉÏ
default-character-set=gbk #»ògb2312,big5,utf8
È»ºóÖØÐÂÆô¶¯mysql
se
Ïà¹ØÎĵµ£º
1 ÉèÖÃphpMyAdmin
Language:Chinese simplified (zh-utf-8)
MySQL ×Ö·û¼¯£ºUTF-8 Unicode (utf8)
MySQL Á¬½ÓУ¶Ô gbk_chinese_ci
2 ´´½¨Êý¾Ý¿âʱ
ÕûÀíÉèÖÃ³É gbk_chinese_ci
3 ÓÃSQL½¨Á¢±íÖÐ
ENGINE=MyISAM DEFAULT CHARSET=gbk;
ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;
4 ¼ì²é±í½á¹¹ÖÐ
varcha ......
ÔÚ֮ǰµÄÎÄÕÂÀÎÒÒѾÌá¹ýÈçºÎ½â¾öJSPÖÐÂÒÂëÎÊÌ⣨½â¾ötomcatÏÂÖÐÎÄÂÒÂëÎÊÌâ £©£¬ÆäÖÐÒ²Ïêϸ½â˵ÁËMYSQLÂÒÂëÎÊÌ⣬ÏàÐÅͨ¹ýÀïÃæµÄ°ì·¨£¬¿Ï¶¨¶¼ÒѾ½â¾öÁËJSPÀïµÄÂÒÂëÎÊÌ⣬²»¹ý»¹ÊÇÓÐЩÈ˵ÄMYSQLÂÒÂëÎÊÌâûÓеõ½½â¾ö£¬°üÀ¨ÎÒ×Ô¼º£¬ËùÒÔÓÖÕÒÁËһЩ×ÊÁÏ£¬Ï£ÍûÕâ´ÎÄÜÍêÈ«½â¾öMYSQLÊý¾Ý¿âµÄÂÒÂëÎÊÌâ¡£
......
ΪʲôѡÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔÒòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾ ......
Á¬½Ó´úÂë1Ö±½ÓÊäÈë
<%
Dim my_conn, sql,rs
Set my_conn = createobject("ADODB.Connection")
my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_ '·þÎñÆ÷Ãû
& "DATABASE=mybase;"_ 'Êý¾Ý¿âÃû
& "UID=root;PWD=111; OPTION=35;" 'Óû§ÃûºÍÃÜÂë
Set rs = Server.Crea ......