MySQLµ¼Èë/µ¼³ö.sqlÎļþ
µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db device_info_table > /home/eric/table.sql
3.½«Êý¾Ý¿âmydbµÄ½á¹¹µ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db --add-drop-table > /home/eric/transfSRV.sql
µ¼Èë.sqlÎļþ
1¡¢µÇ½MySQL
mysql -uroot -p;
2¡¢´´½¨Êý¾Ý¿â
create database transfer_server_db;
3¡¢µ¼ÈëÊý¾Ý¿â½á¹¹Îļþ
mysql -u root -p transfer_server_db < /home/eric/transfSRV.sql
¸ü¸ÄrootÔ¶³ÌȨÏÞ
1¡¢ÔÊÐírootÓû§Ê¹ÓÃÃÜÂëabc´Ó%µØÖ··¢ÆðÔ¶³Ì·ÃÎÊ
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'abc' WITH GRANT OPTION;
mysql>FLUSH RIVILEGES
Ïà¹ØÎĵµ£º
1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º use mydb
2. ʼþ
²é¿´Ê¼þ£º show events
Æô¶¯µ÷¶ÈÆ÷: set global event_scheduer = 1;
²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......
Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......
zz linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ
ÎҵķþÎñÆ÷×°µÄÊÇcentos 5.3,ÓÉÓÚ×ʼ°²×°×öÁËÏêϸµÄ¼Ç¼,ËùÒÔÕû¸ö¹ý³ÌÒ²ÊÇÇá³µÊì·,һ·yumÏÂÀ´£¬¾Í¸ã¶¨ÁË£¬È»ºó¾ÍÊÇÊý¾Ý¿â¡¢ÍøÕ¾µÄ°á¼Ò£¬ÇáËɸ㶨~
¿ÉÊǽñÌìÔÚ¼Ò¿´ÁËϹ«Ë¾µÄÍøÕ¾£¬ÎÊÌâ³öÀ´ÁË~ ÓÐЩ²úÆ·µã»÷²é¿´ÏêϸÐÅÏ¢µÄʱºò£¬ÕÒ²»µ½ÍøÒ³~¾¹ýÒ»·¬Ë¼¿¼£¬·¢ÏÖÊÇmysql ......
SQLÓï·¨ÊÖ²á
Select
ÓÃ;£º
´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨µÄÁеÄÊý¾Ý
Óï·¨£º
SELECT column_name(s) from table_name
½âÊÍ£º
´ÓÊý¾Ý¿âÖÐѡȡ×ÊÁÏÁУ¬²¢ÔÊÐí´ÓÒ»»ò¶à¸ö×ÊÁϱíÖУ¬Ñ¡È¡Ò»»ò¶à¸ö×ÊÁÏÁлò×ÊÁÏÐС£SELECT ³ÂÊöʽµÄÍêÕûÓï·¨Ï൱¸´ÔÓ£¬µ«Ö÷Òª×Ó¾ä¿ÉժҪΪ£º
SELECT select_ ......