·þÎñÆ÷±ÀÀ£ÁË£¬MYSQLû±¸·Ý£¬Ôõô»Ö¸´°¡£¿
¿Í»§µÄ·þÎñÆ÷Öж¾±ÀÀ£ÁË£¬ÎÒ¸øËûÃÇ×öϵͳµÄʱºòûÉèÖÃMYSQLµÄ×Ô¶¯±¸·ÝʲôµÄ£¬Ö÷ÒªÊÇÎÒ²»»á
½ñÌì¿Í»§´òµç»°¹ýÀ´ÁË£¬Ëµ±ÀÀ£ÁË£¬ÎÒµÄÐÄÒ²¸ú×űÀÀ£ÁË
ÄÇÃæµÄÍø¹ÜºÃÏñÒ²²»ÊǺܶ®£¬ÎÒ¸æËßËû°ÑÓ²ÅÌ·ÅÆäËûµçÄÔÖУ¬°ÑÊý¾Ý¿âµÄÎļþ¿½±´³öÀ´£¬ÏÖÔÚÄÜ×öµÄÖ»ÓÐÕâЩ
......
¸÷λ¸÷룬Çë½ÌÒ»¸öÂÒÂëÎÊÌâ
ÎÒµÄvb6.0+mysql Á¬½Ó×Ö·û´®ÊÇ£º
Public Function ChinaTW() As String 'Á¬½ÓÊý¾Ý¿âº¯Êý
ChinaTW = "DRIVER={MySQL ODBC 3.51 Driver};" _
&nbs ......
talbe ÈçÏ£º
Id a b name
--------------------------------------
1 | 12 | 13 | ÕÅÈý |
2 | 14 | 15 | ÕÅÈý |
3 | 16 | 17 | ÕÅÈý | ......
1.Ê×ÏÈÊÇ t_user ±íµÄ¼û±íÓï¾ä£º
SQL code:
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`uid` int(4) NOT NULL,
`uname` varchar(10) NOT NULL,
`uage` int(4) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.È»ºóÊÇÔÚPHPÖÐÖ´ÐеÄÒ»Ìõ²åÈëÓï¾ä£º
PH ......
ÔÚmysqlϽ¨Á˸ö±í£¬½¨±íʱû̫עÒâ±àÂëÎÊÌâ¡£
ĬÈϵÄÓ¦¸ÃÊÇlatin1,ÎÒÔÚlatin1ÏÂÃæ²åÈëÔÚһЩÖÐÎÄÊý¾Ý£¬ÔÚmysqlµÄ¿ØÖÆÌ¨ÏÂûÎÊÌâ
µ«ÊÇÓÃjspÁ¬½ÓÈ¡³öÀ´ÊÇÂÒÂë¡£
·½·¨1£ºset names utf8£¬ÔÚmysql¿ØÖÆÌ¨ÏÔʾÊÇÂÒÂ룬ǰ̨ȡ³öÀ´ÊÇÂÒÂë,set name latin1£¬mysql¿ØÖÆÌ¨ÖÐÎÄ£¬Ç°Ì¨ÂÒÂë
²åÈëÖÐÎÄÊ ......
Ò»Ö±ÒÔÀ´Ð´´æ´¢¹ý³Ì¶¼ÊÇÓõÄMSSQL£¬MSSQLд´æ´¢¹ý³ÌºÜ·½±ã£¬·½±ãÐ޸ġ£
½ñÌìÏÂÎçдMYSQLµÄ´æ´¢¹ý³ÌÏëÂîÈËÁË£¬·ÇµÃÔÚÃüÁîÌáʾ·ûÏ´´½¨´æ´¢¹ý³Ì£¬´´½¨ÒÔºóÓÖ²»ÄÜÖ±½ÓÔÚÃüÁîÐÐÏÂÐ޸쬻¹µÃ½èÖúͼÐι¤¾ßÐ޸ġ£ÎÒÓÃPHPMYADMINÐ޸ģ¬Ò»ÓдíÎó¾ÍÂíÉϰÑÎÒ֮ǰдµÄȫɾ³ýÁË£¬ÓôÃÆ£¡²»ÖªµÀ¸÷λÓÐʲôºÃµÄ·½·¨ºÍ¹¤¾ß£¡
Õ¦¾ ......