ruby gem mysql on cygwin
1£® °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃæ£¬È·¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
download MySQL 5.0 Windows Installer
3£® °²×°MySQL generic source package²¢ÇÒ½¨Á¢Ëü
°ÑtarballÊͷŵ½Ò»¸öÁÙʱÎļþ¡£
./configure
make install
4£® °²×°Ruby Gems
°´ÕÕÕý³£·½Ê½°²×°£¬ÏÂÔØDownload Gems ÊͷŲ¢°²×°¡£
5£® °²×°Rails:
ÏÖÔÚÄãÒѾÓÐGems£¬Äã¿ÉÒÔ°²×°Rails. Ö´ÐУº
gem insall rails –include-dependencies
6. °²×°mysql gem
ÔËÐÐgem°²×°mysql¡£ µ±³öÏÖÑ¡Ôñʱºò£¬²»Òª°²×°mswin32,
Òª°²×°×îеÄUnix °æ±¾¡£
À©Õ¹µÄ°²×°Ö¸ÁÕâÀïûÓÐÈ«²¿·Òë¶¼Êǰ²×°CygwinµÄÖ¸Á
µ«ÊÇÓÐÒ»¾ä»°ÒªÖصã˵£ºWindows isn’t the greatest environment for development.
Windows²¢²»ÊǺܺõĿª·¢»·¾³¡£
Thanks for http://wiki.rubyonrails.org/rails/pages/RailsonWindowsCygwin
Ïà¹ØÎĵµ£º
*************************×Ö·û´®º¯Êý***********************************
mysql> select concat('aa','bb');//×Ö·û´®µÄÁ¬½Ó
mysql> select insert ('beijing2008you',12,3,'me');//×Ö·û´®µÄ²åÈë
+-------------------------------------+
| insert ('beijing2008you',12,3,'me') |
+----------------------- ......
Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54)
¸ÙÒª£º
Ò»£¬Á¬½ÓMySQL
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷
ËÄ, ......
FPDFÄÜÖ§³ÖPDFµÄÖÐÎÄ´òÓ¡£¬È»¶øÈ´´æÔÚ²»ÉٵIJ»ÈçÒâÖ®´¦£¬¾ÝÎÒĿǰµÄʹÓã¬×ܽá³ö¼¸µã£º
1£©FPDFÌṩµÄPdf_Chinese×ÖÌ壬½«GBÕâÖÖ×ÖÌåдÈëÁË´úÂëÖУ¬ÈôÎÒÃÇÏ£ÍûÒýÈëÆäËûµÄÖÐÎÄ×ÖÌ壬Ôò²»ÄÜ·½±ãµØÊ¹ÓÃ
2£©FPDFÊä³öµÄÊý×Ö²¢²»ÃÀ¹Û£¬²»ÈçRuport::Formatter::PDF×Ô´øµÄ×ÖÌå
3£©FPDFÌṩµÄ·½·¨²¢²»¶à£¬¶ÔÓÚÒ»°ãµÄ±¨±í´òÓ¡£¬Óõ ......
½ñÌìÔÚ°ïÅóÓѵ÷ÊÔÒ»¸ö¹ØÓÚ¶àÏ̷߳ÃÎÊͬһÕűíÒýÆðµÄLock wait timeout exceedeµÄÎÊÌ⣬¸Ð¾õÒýÆðµÄÔÒòÓУº
1£¬Ã»ÓнøÐÐÓÅ»¯£¬¾¡Á¿±ÜÃâ¶àÏß³Ì
2£¬¸ù¾ÝËüºóÃæ±¨µÄÒì³££¬ÌáÐÑÎÒ¿ÉÒÔHibernate µÄSessionûÓÐʹÓõõ±£¬(Ò²ÊÇÎÒ½â¾öµÄ·½°¸)
3£¬ÓÃsynchronizedÐÞÊθüбíµÄº¯Êý
¹À¼ÆÊÇÔÀ´³ÌÐòÔÚÐÞ¸ÄÍê¸Ã±íʱÁ¢¿Ì½øÐÐÁ˲åÈë²Ù× ......