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¡¢ÓÒ¼üµã»÷ÎҵĵçÄÔ£¬Ñ¡ÔñÊôÐÔ£¨¼ûͼ-1£©
1¡¢µã»÷¸ß¼¶£¬ÔÚ¶Ô»°¿òµÄϲ¿µã»÷»·¾³±äÁ¿
3¡¢ÔÚϵͳ±äÁ¿¶Ô»°¿òÖУ¬µã»÷н¨½øÐÐÉèÖÃ.
±äÁ¿Ãû£ºJAVA_HOME
±äÁ¿Öµ£ºC:\Program Files\Java\jdk1.6.0_05£¨ÔÚ´ËʹÓõÄÊÇĬÈÏ°²×°Â·¾¶£©
ϵͳ±äÁ¿->±à¼->±ä ......
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡ ......
PL/SQLÓïÑÔ
1¡¢¿ÉÖ´Ðв¿·Ö£¨BEGIN£©
×é³ÉÓï¾ä£º
±äÁ¿¸³ÖµÓï¾ä¡£
Á÷³Ì¿ØÖÆÓï¾ä¡£
Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢ÊÂÎñ¿ØÖÆÓï¾ä¡£
ÓαêÓï¾ä¡£
2¡¢¿ÉÖ´Ðв¿·Ö£¬SQLÓï¾äµÄʹÓÃ
ÔÚ¿ÉÖ´Ðв¿·Ö£¬¿ÉÒÔʹÓÃSQLÓï¾ä£¬µ«ÊDz»ÊÇËùÓеÄSQLÓï¾ä¶¼¿ÉÒÔʹÓá£
¿ÉÒÔʹÓõÄÖ÷ÒªÓУºSELECT¡¢INSERT¡¢UPDATE¡¢DE ......
PHPÖзÖÒ³¿Ï¶¨»áʹÓõ½MySQLµÄlimit,´ó²¿·Ö¶ÔÀàËÆ"select * from title where uid =** order by id desc limit m,n"ºÜÊìϤ,Ò²²»ÊÇÈ«²¿¶¼ÄÜ¿´³öÀïÃæÓÐʲô²»¶Ô,¿ÉÊǵ±ÊÇÔÚ´óÊý¾ÝÁ¿Ï²Ù×÷ÄØ,±ÈÈç°ÙÍòÀàËÆ"select * from title where uid =177 order by id desc limit 1234567,20"¾Í»á·¢ÏÖsqlÖ´ÐеÄʱ¼äÃ÷ ......