mysqlÊý¾Ýµ¼ÈëÎÊÌâ
±ÈÈç°ÑÒ»¸ö.txtÎļþµÄÄÚÈݵ¼Èëµ½mysqlÊý¾Ý¿âµÄÀïÃæµÄtxstÊý¾Ý¿âÀïÃæ£¬£¬Ò³Ãæ±àÂëµÄºÍÊý¾Ý¿âÀïÃæ¶¼ÊDzÉÓÃutf-8½øÐбàÂ루ÏîÄ¿±ØÐë²ÉÓÃutf-8±àÂ룩£¬µ«µ¼Èëµ½Êý¾Ý¿âÀïÃæÖÐÎÄÊÇÂÒÂ룬µ«µ¼Èë³öÀ´¿ÉÒÔÏÔʾÖÐÎÄ£¬£¬ÇëÎÊÔõô½â¾ö°¡ £¬£¬
ÓÃgb2312ºÍÉÏÃæµÄÇé¿öÒ²ÊÇÒ»Ñù£¨µ«ÓÖ²»ÄÜÓÃGB2312£©
ÄÄλ´ó¸ç˵Ï£¬£¬Ð¡µÜ¸Ð¼¤²»¾¡
¶÷ ÄãµÄÊÇlinuxϵͳ»¹ÊÇWINµÄ£¿
¸øÄ㼸¸öÃüÁî°É£¡
Perl code:
//ÏȽøÈëµ½ÄãµçÄÔµÄDÅÌ
D:\>cd AppServ\MySQL\bin
D:\AppServ\MySQL\bin\>mysql -u root -p
Enter password:123 //Õâ¸öÊÇÃÜÂë
mysql>use Êý¾Ý¿âÃû
mysql>source d:\wcnc_db.sql//ÐèÒªµ¼ÈëÊý¾Ý¿âµÄ·¾¶
win
WIN
ÎÒ¸øÁËÄãDOS ÃüÁîÁË
ÓÃÁËû£¿¿ÉÒÔ°É£¿
ºÃÏñ»¹ÊDz»Ðа¡
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......