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

mysql µ¼ÈëCVSÎÊÌâ

CVS ÀïÃæÓÐÖÐÎÄµÄ µ¼Èëµ½ mysql Ö®ºó ¾ÍûÓÐÊý¾ÝÏÔʾ
µ« ×ÖĸºÍ Êý×Ö¾ÍÓÐÊý¾ÝÏÔʾ
ÎÒµ¼ÈëµÄʱºò£¬ Êý¾Ý¿â±íʹÓÃUTF8 µ¼ÈëµÄʱºò ҲѡÔñÁË UTF8
ÇëÎÊÕâÊÇʲôÎÊÌâÄØ£¿
лл
˵Ã÷Ò»ÏÂÄãµÄ

show create table xxx;
show variables like 'char%';

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

ÎÒµ¼ÈëÖ®ºó Ëû²»ÊÇÂÒÂ룬 ÊÇ×Ö¶ÎÀïÃæ£¬Èç¹ûÊÇÖÐÎÄµÄ ¼¸Ö±½ÓûÓмǼ - -£¡ º¹

ÒýÓÃ˵Ã÷Ò»ÏÂÄãµÄ

show create table xxx;
show variables like 'char%';



Èç¹ûÄã²»Ìṩ±ØÒªµÄÐÅÏ¢£¬±ðÈ˺ÜÄѲÂÖÐÄãµÄʵ¼ÊÎÊÌâ¡£

CVSÎļþÊÇÓбàÂëµÄ,µ¼ÈëʱҪÉ趨À´Ò»ÖÂ,µ¼Èë²ÅÄܳɹ¦!

²Î¿¼ http://dev.mysql.com/doc/refman/5.1/en/load-data.html

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [CHARACTER SET charset_name]
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
&


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ