mysqlѧϰ3
ÉÏƪÎÒÃÇѧ»áÁËÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í£¬²¢ÖªµÀÈçºÎÏòÊý¾Ý¿â±íÖÐÌí¼Ó¼Ç¼¡£
ÄÇôÎÒÃÇÈçºÎ´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÄØ£¿
1¡¢´ÓÊý¾Ý¿â±íÖмìË÷ÐÅÏ¢
ʵ¼ÊÉÏ£¬Ç°ÃæÎÒÃÇÒѾÓõ½ÁËSELECTÓï¾ä£¬ËüÓÃÀ´´ÓÊý¾Ý¿â±íÖмìË÷ÐÅÏ¢¡£
selectÓï¾ä¸ñʽһ°ãΪ£º
SELECT ¼ìË÷¹Ø¼ü´Ê from ±»¼ìË÷µÄ±í WHERE ¼ìË÷Ìõ¼þ(¿ÉÑ¡)
ÒÔÇ°ËùʹÓõē * ”±íʾѡÔñËùÓеÄÁС£
ÏÂÃæ¼ÌÐøʹÓÃÎÒÃÇÔÚÉÏƪÎÄÕÂÖд´½¨µÄ±ímytable£º
2¡¢²éѯËùÓÐÊý¾Ý£º
mysql> select * from mytable;
+----------+------+------------+----------+
| name | | birth | birthaddr |
+----------+------+------------+--------+
| abccs |f | 1977-07-07 | china |
| mary |f | 1978-12-12 | usa |
| tom |m | 1970-09-02 | usa |
+----------+------+------------+----------+
3 row in set (0.00 sec)
3¡¢ÐÞÕý´íÎó¼Ç¼£º
¼ÙÈçtomµÄ³öÉúÈÕÆÚÓдíÎó£¬Ó¦¸ÃÊÇ1973£09£02£¬Ôò¿ÉÒÔÓÃupdateÓï¾äÀ´ÐÞÕý£º
mysql> update mytable set birth = "1973-09-02" where name = "tom";
ÔÙÓÃ2ÖеÄÓï¾ä¿´¿´ÊÇ·ñÒѸüÕý¹ýÀ´¡£
4¡¢Ñ¡ÔñÌض¨ÐÐ
ÉÏÃæÐÞ¸ÄÁËtomµÄ³öÉúÈÕÆÚ£¬ÎÒÃÇ¿ÉÒÔÑ¡ÔñtomÕâÒ»ÐÐÀ´¿´¿´ÊÇ·ñÒѾÓÐÁ˱仯£º
mysql> select * from mytable where name = "tom";
+--------+------+------------+------------+
| name | | birth | birthaddr |
+--------+------+------------+------------+
| tom |m | 1973-09-02 | usa |
+--------+------+------------+------------+
1 row in set (0.06 sec)
ÉÏÃæWHEREµÄ²ÎÊýÖ¸¶¨Á˼ìË÷Ìõ¼þ¡£ÎÒÃÇ»¹¿ÉÒÔÓÃ×éºÏÌõ¼þÀ´½øÐвéѯ£º
mysql> SELECT * from mytable WHERE = "f" AND birthaddr = "china";
+--------+------+------------+------------+
| name | | birth | birthaddr |
+--------+------+------------+------------+
| abccs |f | 1977
Ïà¹ØÎĵµ£º
ÔÎÄÁ´½Ó http://database.51cto.com/art/200904/117957.htm
ÒÔÏÂÊÇÉæ¼°µ½²åÈë±í¸ñµÄ²éѯµÄ5ÖָĽø·½·¨£º
1)ʹÓÃLOAD DATA INFILE´ÓÎı¾ÏÂÔØÊý¾ÝÕ⽫±ÈʹÓòåÈëÓï¾ä¿ì20±¶¡£
2)ʹÓôøÓжà¸öVALUESÁбíµÄINSERTÓï¾äÒ»´Î²åÈ뼸ÐÐÕ⽫±ÈʹÓÃÒ»¸öµ¥ÐвåÈëÓï¾ä¿ì¼¸±¶¡£µ÷Õûbulk_insert_buffer_size±äÁ¿Ò²ÄÜÌá¸ß£¨Ïò°üº¬Ðеıí ......
ÊÔÑé1
ÊÂÎñ1£º
#!/usr/bin/python
import time
import MySQLdb;
conn = MySQLdb.connect(host="localhost",port=3306,user="root",passwd="asdf",db="test",unix_socket="/data/mysql_3306/mysql.sock")
cursor = conn.cursor()
cursor.execute("select * from test")
while str!="1":
str = r ......
Êý¾Ý¿âµÄÓÅ»¯ÊÇϵͳÓÅ»¯µÄÖØÒª·½Ã棬¶øÊý¾Ý¿âÓÅ»¯µÄ»ù´¡ÊÇ»ùÓÚͳ¼ÆÊý¾Ý£¬ÏÂÃæµÄÕâЩÃüÁî¿ÉÒÔ°ïÖúÎÒÃÇÁ˽âÊý¾Ý¿âµÄ״̬¡£±ÈÈçÓÃshow table status from ecl where rows>10000;¿ÉÒÔ¿´ÄÄЩÊý¾Ý¿â±í±È½Ï´ó£¬È»ºó¿´¿´ÕâЩ±íµÄÉèÖá¢Ë÷ÒýµÈÊÇ·ñÓÐÎÊÌâ¡£
1. show tables»òshow tables from dat ......
truncate table Çå¿Õ±í£¬ºÍdeleteÏàËÆ£¬µ«ÊÇÔÚ±í·Ç³£´óµÄʱºò£¬ËüÊÇÖð²½Êͷŵġ£
insert Èç¹ûÔÚ²åÈëʱ£¬Ä³¸ö×ֶδæÔÚ£¬ÎÒÏë¸üпÉÒÔͨ¹ý insert into tablename values() on duplicate key update id=id+1;
insert into tablename values(default) ĬÈÏ×ÔÔö³¤
select last_insert_id() È¡×îºó²åÈëÒ»Ìõ¡£ ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
1¡¢ÈôÊÇÁ¬½Óµ½±¾»úÉϵÄMYSQL£ºÊ×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬»òÕß½«mysql\bin°²×°Â·¾¶ÉèÖÃÔÚ»·¾³±äÁ¿pathÖУ¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëÇ°± ......