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

PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°

PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
ʹÓõÄÈí¼þ°æ±¾
DBI-1.604.tar.gz
DBD-mysql-4.006.tar.gz
½¨ÒéʹÓÃÒÔÉϰ汾´îÅ䣬·ñÔò¿ÉÄÜÁ¬½Ómysql´íÎó
Ò»¡¢DBIµÄ°²×°
 wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
 tar -zxvf DBI-1.604.tar.gz
 cd DBI-1.604
 perl Makefile.PL
 make
 make test
 make install
 
¶þ¡¢DBDµÄ°²×°
 
 ×¢ÒâmysqlµÄ»·¾³±äÁ¿£¬ÈôûÓÐÔòÓà Ìí¼Ó/usr/local/mysql/binµ½»·¾³±äÁ¿PATHÖÐ
 PATH=/usr/local/mysql/bin:$PATH;
 export PATH (mysqlµÄ°²×°Â·¾¶¸ù¾Ýʵ¼ÊÇé¿öÌîд)
 
 wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.006.tar.gz
 tar -zxvf DBD-mysql-4.006.tar.gz
 cd DBD-mysql-4.006
 perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
 make
 make test
 make install
 
Èý¡¢ÆäËü¿ÉÄÜ·¢ÉúµÄ×´¿ö
Èç¹ûÔËÐÐij¸öµ÷ÓÃMYSQLÊý¾Ý¿âµÄ³ÌÐòʱ³öÏÖÈçÏÂϵͳÌáʾ£º
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206. at (eval 2) line 3
ÄÇô˵Ã÷DBD::MYSQLδ°²×°³É¹¦¡£
´Ëʱ½«/usr/local/mysql/include/mysql/*
¸´ÖƵ½/usr/include/
ͬʱ½«/usr/local/mysql/lib/mysql/*
¸´ÖƵ½/usr/lib/(64λϵͳ/usr/lib64/)
È»ºóʹÓÃperl Makefile.PLÉèÖû·¾³£¬ÔÙ½øÐкóÐøµÄÕý³£°²×°£¬¾ÍÄÜÕýÈ·Á¬½Óµ½MYSQLÊý¾Ý¿â¡£


Ïà¹ØÎĵµ£º

MySQLË÷Òý·ÖÎöºÍÓÅ»¯Ë÷Òý·ÖÎö

Ë÷Òý
¡¡¡¡Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬ËùÓÐMySQLË÷Òý¶¼ÒÔB-Ê÷µÄÐÎʽ±£´æ¡£Èç¹ûûÓÐË÷Òý£¬Ö´ÐвéѯʱMySQL±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨ÃèÕû¸ö±íµÄËùÓмǼ£¬Ö±ÖÁÕÒµ½·ûºÏÒªÇóµÄ¼Ç¼¡£±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£Èç¹û×÷ΪËÑË÷Ìõ¼þµÄÁÐÉÏÒѾ­´´½¨ÁËË÷Òý£¬MySQLÎÞÐèɨÃèÈκμǼ¼´¿ÉѸËٵõ½Ä¿±ê¼Ç ......

ʵÏÖJavaÁ¬½Ómysql£¨Ô´Â룩£¡

JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾­¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno  char[7]  NO NULL Primary Key;
sname  varchar[8]  NO NULL;
sex  char[2]  NO NULL; ......

MySQLËøÓ÷¨½éÉÜ

http://book.51cto.com/art/200803/68118.htm
ÕªÒª£º¡¶ÉîÈëdz³öMySQL——Êý¾Ý¿â¿ª·¢¡¢ÓÅ»¯Óë¹ÜÀíά»¤¡·´ÓÊý¾Ý¿âµÄ»ù´¡¡¢¿ª·¢¡¢ÓÅ»¯¡¢¹ÜÀí4·½Ãæ¶ÔMySQL½øÐÐÁËÏêϸµÄ½éÉÜ£¬ÆäÖÐÿһ²¿·Ö¶¼¶ÀÁ¢³Éƪ£¬Ã¿Ò»ÆªÓÖ°üÀ¨¶à¸öÕ½ڡ£±¾ÊéÃæÏòʵÓã¬ÄÚÈݸ²¸Ç¹ã·º£¬½²½âÓÉdzÈëÉÊʺÏÓÚ¸÷¸ö²ã´ÎµÄ¶ÁÕß¡£
µÚ20ÕÂ ËøÎÊÌâ
ËøÊÇ ......

MysqlÖ»µ¼µ¥ÐеÄINSERTÓï¾ä


Ö»µ¼´´½¨±íµÄ½á¹¹£º
bin/mysqldump -d --add-drop-database=FALSE --add-drop-table=FALSE -usosodb -p sosodb TEST > /tmp/test.sql
Ö»µ¼µ¥ÐеÄINSERTÓï¾ä:
bin/mysqldump --extended-insert=FALSE --add-drop-database=FALSE --add-drop-table=FALSE --create-options=FALSE -t --add-locks=FALSE -usosodb -p so ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ