Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â¡£


Ïà¹ØÎĵµ£º

ÀûÓÃBind DLZ MySQL ¹¹½¨ÖÇÄÜDNS

±¾ÎÄÀ´×Ô: ITÔËάר¼ÒÍø ×÷Õß: NetSeek ÈÕÆÚ: 2009-3-8 19:52 ÔĶÁ: 742 ÈË ´òÓ¡ ÊÕ²Ø DNS, Bind, DLZ, ÖÇÄÜ, MySQL ×÷Õß:NetSeek  http://www.linuxtone.org
ÈÕÆÚ:2009-3-7 gmail:cnseek@gmail.com
ÍÆ¼öÏÂÔØPDF°æ£¨·½±ã²éÔÄ):http://www.linuxtone.org/project/cdn/bind-dlz-view.pdf
¡¾Ìâ ¸Ù¡ ......

MySQL°²×°

MysqlµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¬½¨ÒéÑ¡Ôñ4.0.20d°æ±¾¡£ÕâÀï²»Ïêϸ˵Ã÷¡£
¡¡¡¡ÏÂÔØ»ñµÃMysqlµÄfor win32°²×°°üºó£¬ÓÃwinzip½âѹËõ£¬Ö±½ÓÔËÐÐsetup.exe£¬ÐèҪעÒâµÄÊÇÑ¡ÔñÒ»¸ö°²×°Â·¾¶£¬µ±È»£¬°²×°Â·¾¶¿ÉÒÔÈÎÒ⣬½¨ÒéÑ¡ÔñC:\MySQLĿ¼¡£°²×°Íê³ÉºóMySQLÒ²¾ÍÍê³ÉÁË¡£Ä¬ÈϵÄÓû ......

×¢ÒâMysqlÊý¾Ý½Ø¶Ï

Beware of MySQL Data Truncation
http://www.mysqlperformanceblog.com/2009/02/07/beware-of-mysql-data-truncation/
±ÈÈ磺ÓÐÒ»¸ö±íaritcleºÍÁíÒ»¸ö±íarticle_comment£¬¹ØÁªÊÇarticleµÄid
CREATE TABLE `article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
......

MysqlËø»úÖÆ

mysqlËø»úÖÆ
mysqlÖÐ¶Ô±í¼¶µÄ´æ´¢ÒýÇæÀ´ËµÊÇÊÍ·ÅËÀËøµÄ£¬±ÜÃâËÀËø¿ÉÒÔÕâÑù×öµ½:ÔÚÈκβéѯ֮ǰÏÈÇëÇóËø£¬²¢ÇÒ°´ÕÕÇëÇóµÄ˳ÐòËø±í¡£
MysqlÖÐÓÃÓÚwrite(д)µÄ±íËøµÄʵÏÖ»úÖÆÈçÏ£º
Èç¹û±íûÓмÓËø£¬ÄÇô¾Í¼ÓÒ»¸öÐ´Ëø¡£·ñÔòµÄ»°£¬½«ÇëÇó·Åµ½Ð´Ëø¶ÓÁÐÖС£
mysqlÖÐÓÃÓÚread(¶Á)µÄ±íËøµÄʵÏÖ»úÖÆÈçÏ£º
Èç¹û±íûÓмÓËø£¬ÄÇô ......

How to use MySql via Linq to SQL

The vs2008 and vs2010 don't support the generation LINQ to SQL business objects from a MySQL database, if you drop a MySql table to a Linq to Sql Class, it will popup a "The selected object(s) use an unsupported data provider" error.
Generation tool DBLinq
DbLinq is a LINQ to SQL data co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ