railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ
1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\ Thu Jul 30 22:16:15 +0800 2009
Status: 500 Internal Server Error
unknown error
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlload'
c:/ruby/lib/ruby/1.8/dl/import.rb:27:in `each'
c:/ruby/lib/ruby/1.8/dl/import.rb:27:in `dlload'
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.3-x86-mswin32/lib/sqlite3/driver/dl/api.rb:31
... ...
´ÓÍøÉÏÏÂÔØsqlite3.dll¡¢sqlite3.exe¿½±´µ½ÏµÍ³Ä¿Â¼Ï¼´¿É½â¾ö¡£
2¡¢Èç¹ûʹÓÃmysql£¬Ä¿Ç°rail2.3.3ÅäºÏmysql5±È½ÏÕý³££¬mysql6ÔÝʱÓÐЩÎÊÌâ¡£ÔÚ°²×°mysql5ºóÒª½«libmySQL.dll¿½±´µ½c:\ruby\binĿ¼Ï£¬±£Ö¤Çý¶¯¼ÓÔØÕýÈ·¡£
Ïà¹ØÎĵµ£º
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µ ......
Analyze Table
MySQL µÄOptimizer£¨ÓÅ»¯Ôª¼þ£©ÔÚÓÅ»¯SQLÓï¾äʱ£¬Ê×ÏÈÐèÒªÊÕ¼¯Ò»Ð©Ïà¹ØÐÅÏ¢£¬ÆäÖоͰüÀ¨±íµÄcardinality£¨¿ÉÒÔ·ÒëΪ“É¢Áг̶Ȕ£©£¬Ëü±íʾij¸öË÷Òý¶ÔÓ¦µÄÁаüº¬¶àÉÙ¸ö²»Í¬µÄÖµ——Èç¹ûcardinality´ó´óÉÙÓÚÊý¾ÝµÄʵ¼ÊÉ¢Áг̶ȣ¬ÄÇôË÷Òý¾Í»ù±¾Ê§Ð§ÁË¡£
ÎÒÃÇ¿ÉÒÔʹÓÃSHOW& ......
Èý²½×ߣº
1.ÔÚwindows-->perspective-->DB browser
2.Create a database connection profile
Çý¶¯ÏÂÔØ£º http://dev.mysql.com/downloads/
ÎļþÃû£ºmysql-connector-java-5.0.4-bin
3.Open a database connection
Á´½Óʱ¿ÉÄܳöÏÖ´íÎó£¬ÄÇôÇë³¢ÊÔÈçÏ·½·¨£º
Err ......
1¡¢mysql Êý¾Ý¿âûÓÐÔöÁ¿±¸·ÝµÄ»úÖÆ£¬µ±Êý¾ÝÁ¿Ì«´óµÄʱºò±¸·ÝÊÇÒ»¸öºÜ´óµÄÎÊÌâ¡£»¹ºÃ mysql Êý¾Ý¿âÌṩÁËÒ»ÖÖÖ÷´Ó±¸·ÝµÄ»úÖÆ£¬Æäʵ¾ÍÊǰÑÖ÷Êý¾Ý¿âµÄËùÓеÄÊý¾Ýͬʱдµ½±¸·ÝÊý¾Ý¿âÖС£ÊµÏÖ mysql Êý¾Ý¿âµÄÈȱ¸·Ý¡£
¡¡¡¡2¡¢ÒªÏëʵÏÖË«»úµÄÈȱ¸Ê×ÏÈÒªÁ˽âÖ÷´ÓÊý¾Ý¿â·þÎñÆ÷µÄ°æ±¾µÄÐèÇó¡£ÒªÊµÏ ......
lect ASIN('foo');
¡¡¡¡-> 0.000000
ATAN(N)
¡¡·µ»ØNµÄ·´ÕýÇÐÖµ
mysql> select ATAN(2);
¡¡¡¡-> 1.107149
mysql> select ATAN(-2);
¡¡¡¡-> -1.107149
ATAN2(X,Y)
¡¡·µ»Ø2¸ö±äÁ¿XºÍYµÄ·´ÕýÇÐ(ÀàËÆY/XµÄ·´ÕýÇÐ,·ûºÅ¾ö¶¨ÏóÏÞ)
mysql> select ATAN(-2,2);
¡¡¡¡-> -0.785398
mysql> ......