Mysql×Ö·û±àÂëÂÒÂë½â¾ö·½·¨
µ¼³öÊÇ,ûÓÐÖ¸¶¨±àÂë
·½·¨Ò» phpmyadmin´¦Àí·½Ê½
¼ì²éphp-mbstringÊÇ·ñÓпÉ×°,ûÓа²×°ÉÏ yum -y install php-mbstring
´ò¿ªphpmyadmin Öе¼³ö,ÔÙ´Óphpmyadmin µ¼ÈëÊÇѡȡ¶þÖÆ½ø(binary)
Èç¹û»¹²»ÐÐ,ÔÚmy.cnf mysqldÖмÓÈë default-character=ÄãµÄ±àÂë, ÖØÆômysql ÔÙÊÔ
·½·¨¶þ mysqldump ´¦Àí·½Ê½
µ¼³ö·½Ê½
mysqldump -u root -p --default-character-set=±àÂë Êý¾ÝÃû³Æ> file.sql
Àý
mysqldump -u root -p --default-character-set=big5 discuss_chi> dis.sql
---------------------
µ¼È뷽ʽ
mysqldump -u root -p --default-character-set=±àÂë Êý¾ÝÃû³Æ< file.sql
Àý
mysql -u root -p --default-character-set=binary -f discuss_chi<file.sql
Ò²¿ÉÒÔ
mysql -u root -p --default-character-set=big5 -f discuss_chi<dis.sql
µ«Êǽ¨ÒéʹÓöþ½øÖÆ,°²È«D!
·½·¨Èý£º
ÒÔÔÀ´µÄ×Ö·û¼¯Îªlatin1ΪÀý£¬Éý¼¶³ÉΪutf8µÄ×Ö·û¼¯¡£ÔÀ´µÄ±í: old_table (default charset=latin1)£¬ÐÂ±í£ºnew_table(default charset=utf
µÚÒ»²½£ºµ¼³ö¾ÉÊý¾Ý
mysqldump --default-character-set=latin1 -h localhost -u root -B my_db --tables old_table > old.sql
µÚ¶þ²½£º×ª»»±àÂë(ÀàËÆunix/linux»·¾³ÏÂ)
iconv -f gb2312 -t utf-8 -c old.sql > new.sql
»òÕß¿ÉÒÔÈ¥µô -f ²ÎÊý£¬ÈÃiconv×Ô¶¯ÅжÏÔÀ´µÄ×Ö·û¼¯
iconv -t utf-8 -c old.sql > new.sql
ÔÚÕâÀ¼Ù¶¨ÔÀ´µÄÊý¾ÝĬÈÏÊÇgb2312±àÂë¡£
µÚÈý²½£ºµ¼Èë
ÐÞ¸Äold.sql£¬ÔÚ²åÈë/¸üÐÂÓï¾ä¿ªÊ¼Ö®Ç°£¬Ôö¼ÓÒ»ÌõsqlÓï¾ä£º
"SET NAMES utf8;"
mysql -h localhost -u root -p my_db > new.sql
Ïà¹ØÎĵµ£º
MySQLÎå¸ö²éѯÓÅ»¯·½·¨
ÊìϤSQLµÄÈ˶¼ÖªµÀ£¬Íê³Éͬһ¸öÈÎÎñ£¬SQL¿ÉÄÜÓжàÖÖд·¨£¬µ«²»Í¬Ð´·¨µÄ²éѯ
ÐÔÄÜ¿ÉÄÜ»áÓÐÌìÈÀÖ®±ð£¬±¾ÎÄÁоٳöÎå¸ö²éѯÓÅ»¯µÄ·½·¨
£¬µ±È»£¬ÓÅ»¯µÄ·½·¨»¹Óкܶࡣ¡¡¡¡
1¡¢ÓÅ»¯Êý¾ÝÀàÐÍ
MySQL
ÖÐÊý¾ÝÀàÐÍÓжàÖÖ£¬Èç¹ûÄãÊÇÒ»ÃûDBA£¬ÕýÔÚ°´ÕÕÓÅ»¯µÄÔÔò¶ÔÊý¾ÝÀàÐͽøÐÐÑϸñµÄ¼ì²é£¬µ«¿ª·¢
ÈËÔ ......
MySQL
ÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£ÓÉ
ÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»ÌØµã£¬Ðí¶àÖÐСÐÍÍøÕ¾ÎªÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ÎªÍøÕ¾Êý¾Ý¿â¡£
1¡¢phpMyAdmin£¨http://www.phpmyadmin.ne ......
°²×°mysql
gem install mysql
ʹÓÃmysql£¬È磬rake db:migrate
»á±¨´í£º
E:\study\ruby\rails_space>rake db:migrate
(in E:/study/ruby/rails_space)
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
193: ......
1.MySQL´´½¨ÊÓͼµÄ¼òµ¥Óï¾äΪ£ºCREATE VIEW view_name AS SELECT * from TABLE_NAME;
²»ÄܶԴ¥·¢Æ÷´´½¨ÊÓͼ(VIEW)¡£µ«ÊÇÔÚ5.1.4ÖÐÊÇÕâÑùÃèÊöµÄ£¬A view can be created from many kinds of SELECT statements. It can refer to base tables or other views. It can use joins, UNION, and subqueries¡£´óÖÂÒâ˼ÊÇÊÓÍ ......