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

mysqlÔÚcmdϵÄһЩÓï¾ä

ÉèÖÃ×ֶεÄĬÈÏÖµ£º
    ´´½¨±íµÄʱºò£ºcreate table
tablename(columnname columntype default
defaultvalue);
    Ð޸ıíµÄʱºò£ºalter table
tablename alter column
columnname set 
default
deflaultvalue;


Ïà¹ØÎĵµ£º

Ò»¸ö¸´ÔÓµÄmysql²éѯÓï¾ä(case,when,then,left join )

select `a`.`id` AS `id`,`a`.`UserName` AS `UserName`,
(case when (`a`.`sRegDate` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`sRegDate`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `sRegDate`,(case when (`a`.`feeendtime` = _utf8'1990-01-01 00:00:00.0') then _ut ......

MySQL³£Óõĵ¼Èëµ¼³öÃüÁî

³£ÓõÄ:
µ¼³ö
mysqldump -hyour_host -uyour_username -pyour_password database_name > file.sql
µ¼Èë
mysql -hyour_host -uyour_username -pyour_password database_name < file.sql
»òÕßÏÈÓÃmysql¿Í»§¶ËµÇ½ºó£¬
>\. file.sql
Ò²¿ÉÒÔÍê³Éµ¼È빦ÄÜ
ÉÏÃæµÄÁ½¸öÃüÁî½áºÏÆðÀ´Ó㬿ÉÒÔÍê³É½«Ò»¸öÊý¾Ý¿âµÄ ......

¸ßÐÔÄÜMySQLѧϰ±Ê¼Ç(¶þ)

 Ç°×ºË÷Òý
(1)Èç¹ûÒÔ¶à¸ö×Ö¶Î×÷ΪË÷Òý£¨a,b£¬c)×÷Ϊһ¸ökey,ÔÚ²éѯʱ·Ö¸ù¾ÝÆ¥ÅäÇé¿öÊÇ·ñʹÓÃË÷Òý£¬ËùÒÔ£¬a/ a,b/ a,b,cÕâÑùµÄ²éѯ¶¼ÄÜʹÓõ½£¬µ«ÊÇb,a/a,c/c,aµÈ²»·û֪ǰ׺ƥÅä¾Í²»ÄÜʹÓã¬ËùÒÔÔÚдsqlʱÐèҪעÒâ
(2)¶ÔÓںܳ¤µÄ×Ö·û´®ÐèÒªÉú³Ékeyʱ£¬¿ÉÒÔÕÒ³ö×ʹÓõÄ×Ö·û´®µÄ×î³£¼ûǰ׺(ǰN¸ö×ÖÌõ×÷Ϊkey,¶ø²»Êǽ ......

MySQLµÄ¿ªÔ´Èȱ¸·Ý¹¤¾ßXtrabackup1.2

InnoDB,ÆÕͨµÄmysql
dump±¸·ÝÏÂÀ´,mysql»Ö¸´ÆðÀ´ÂýµÃÒª
ËÀ.
ÓÚÊÇÍøÉÏÕÒÁ˺þÃ,²ÅÕÒµ½Õâô¸ö¹¤¾ß
.
http://launchpad.net/percona-xtrabackup/release-1.2/release-1.2/+download/xtrabackup-1.2.tar.gz
ÏȲâÊÔÏÂÔÙ˵.
¿ÉÒÔÕâô±¸·Ý:
MyISAM
񡜧
/usr/local/mysql/bin/mysqldump -uyejr -pyejr
--default-char ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ