Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

MySQL 5.0.16 ÂÒÂëÎÊÌâ´¦Àí°ì·¨


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 ......

mysqlÖÐÎÄÂÒÂëÎÊÌâ½â¾ö·½°¸

    ÔÚ֮ǰµÄÎÄÕÂÀÎÒÒѾ­Ìá¹ýÈçºÎ½â¾öJSPÖÐÂÒÂëÎÊÌ⣨½â¾ötomcatÏÂÖÐÎÄÂÒÂëÎÊÌâ £©£¬ÆäÖÐÒ²Ïêϸ½â˵ÁËMYSQLÂÒÂëÎÊÌ⣬ÏàÐÅͨ¹ýÀïÃæµÄ°ì·¨£¬¿Ï¶¨¶¼ÒѾ­½â¾öÁËJSPÀïµÄÂÒÂëÎÊÌ⣬²»¹ý»¹ÊÇÓÐЩÈ˵ÄMYSQLÂÒÂëÎÊÌâûÓеõ½½â¾ö£¬°üÀ¨ÎÒ×Ô¼º£¬ËùÒÔÓÖÕÒÁËһЩ×ÊÁÏ£¬Ï£ÍûÕâ´ÎÄÜÍêÈ«½â¾öMYSQLÊý¾Ý¿âµÄÂÒÂëÎÊÌâ¡£
......

*nix»·¾³ÏÂÔ´Âë±àÒë°²×°mysql

 ÎªÊ²Ã´Ñ¡ÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔ­Òòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾ ......

asp Á¬½Ó mysql ´úÂë

 Á¬½Ó´úÂë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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ