MYSQLʵÏÖ×Ô¶¯±¸·Ý
ÔÚwindowsϵͳÏ MYSQL ¿ÉÒÔͨ¹ý±àдÅú´¦Àí ÔËÓÃMySQL mysqldump -u root -proot --default-character-set=gbk --databases xxxxx >C://xxxxx.sql Óï¾äÀ´´ïµ½¶¨Ê±±¸·ÝÊý¾Ý¿â(xxxxÊÇÊý¾Ý¿âµÄÃû×Ö)
linux ÏÂÒ²¿ÉÒÔÓà shell½Å±¾ À´ÊµÏÖ
µ«ÊÇÔÚLinux ÈçºÎʵÏÖÿÌì×Ô¶¯±¸·ÝÊý¾Ý¿â¶øÇÒ¶¼±£´æÔÚÒ»¸öÌØ¶¨µÄÎļþ¼ÐÀï²¢²»È¥Ìæ»»¡£¡£
ûÈ˸ø¸ö ½¨Òé°¡£¡£¡£¡
{{--
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......