mysql textºÍblob±È½Ï
1.
blobÊǶþ½øÖÆ´ó¶ÔÏó,¿ÉÒÔÈÝÄɿɱäÁ¿ÊýÁ¿µÄÊý¾Ý,ÆäÖÐblob·ÖΪ4ÖÐÀàÐÍ:TINYBLOB,BLOB,mediumblobºÍLongBlob,ËûÃÇÈÝÄɵij¤¶ÈÊDz»Í¬µÄ.
TextͬÑùÒ²·ÖΪËÄÖÖÀàÐÍ:TINYTEXT¡¢TEXT¡¢MEDIUMTEXTºÍLONGTEXT
2.
blob±»ÊÓΪ¶þ½øÖÆ×Ö·û´®,Text±»ÊÓΪ·Ç¶þ½øÖÆ×Ö·û´®;
blobÁÐûÓÐ×Ö·û¼¯£¬²¢ÇÒÅÅÐòºÍ±È½Ï»ùÓÚÁÐÖµ×Ö½ÚµÄÊýÖµÖµ¡£
TEXTÁÐÓÐÒ»¸ö×Ö·û¼¯£¬²¢ÇÒ¸ù¾Ý×Ö·û¼¯µÄУ¶Ô¹æÔò¶ÔÖµ½øÐÐÅÅÐòºÍ±È½Ï¡£
ÔÚTEXT»òBLOBÁеĴ洢»ò¼ìË÷¹ý³ÌÖУ¬²»´æÔÚ´óСдת»»,µ±Î´ÔËÐÐÔÚÑϸñģʽʱ£¬Èç¹ûÄãΪBLOB»òTEXTÁзÖÅäÒ»¸ö³¬¹ý¸ÃÁÐÀàÐ͵Ä×î´ó³¤¶ÈµÄÖµÖµ£¬Öµ±»½ØÈ¡ÒÔ±£Ö¤Êʺϡ£Èç¹û½ØµôµÄ×Ö·û²»Êǿոñ£¬½«»á²úÉúÒ»Ìõ¾¯¸æ¡£Ê¹ÓÃÑϸñSQLģʽ£¬»á²úÉú´íÎ󣬲¢ÇÒÖµ½«±»¾Ü¾ø¶ø²»ÊǽØÈ¡²¢¸ø³ö¾¯¸æ.ÔÚ´ó¶àÊý·½Ã棬¿ÉÒÔ½«BLOBÁÐÊÓΪÄܹ»×ã¹»´óµÄVARBINARYÁС£Í¬Ñù£¬¿ÉÒÔ½«TEXTÁÐÊÓΪVARCHARÁС£
3.
BLOBºÍTEXTÔÚÒÔϼ¸¸ö·½Ã治ͬÓÚVARBINARYºÍVARCHAR.
BLOBºÍTEXTÁв»ÄÜÓÐĬÈÏÖµ.
µ±±£´æ»ò¼ìË÷BLOBºÍTEXTÁеÄֵʱ²»É¾³ýβ²¿¿Õ¸ñ¡£(ÕâÓëVARBINARYºÍVARCHARÁÐÏàͬ£©.
¶ÔÓÚBLOBºÍTEXTÁеÄË÷Òý£¬±ØÐëÖ¸¶¨Ë÷Òýǰ׺µÄ³¤¶È¡£¶ÔÓÚCHARºÍVARCHAR£¬Ç°×º³¤¶ÈÊÇ¿ÉÑ¡µÄ.
LONGºÍLONG VARCHAR¶ÔÓ¦MEDIUMTEXTÊý¾ÝÀàÐÍ¡£ÕâÊÇΪÁ˱£Ö¤¼æÈÝÐÔ¡£Èç¹ûTEXTÁÐÀàÐÍʹÓÃBINARYÊôÐÔ£¬½«ÎªÁзÖÅäÁÐ×Ö·û¼¯µÄ¶þԪУ¶Ô¹æÔò.
MySQLÁ¬½Ó³ÌÐò/ODBC½«BLOBÖµ¶¨ÒåΪLONGVARBINARY£¬½«TEXTÖµ¶¨ÒåΪLONGVARCHAR¡£ÓÉÓÚBLOBºÍTEXTÖµ¿ÉÄÜ»á·Ç³£³¤£¬Ê¹ÓÃËüÃÇʱ¿ÉÄÜÓöµ½Ò»Ð©Ô¼Êø.
BLOB»òTEXT¶ÔÏóµÄ×î´ó´óСÓÉÆäÀàÐÍÈ·¶¨£¬µ«ÔÚ¿Í»§¶ËºÍ·þÎñÆ÷Ö®¼äʵ¼Ê¿ÉÒÔ´«µÝµÄ×î´óÖµÓÉ¿ÉÓÃÄÚ´æÊýÁ¿ºÍͨÐÅ»º´æÇø´óСȷ¶¨¡£Äã¿ÉÒÔͨ¹ý¸ü¸Ämax_allowed_packet±äÁ¿µÄÖµ¸ü¸ÄÏûÏ¢»º´æÇøµÄ´óС£¬µ«±ØÐëͬʱÐ޸ķþÎñÆ÷ºÍ¿Í»§¶Ë³ÌÐò¡£ÀýÈ磬¿ÉÒÔʹÓà mysqlºÍmysqldumpÀ´¸ü¸Ä¿Í»§¶ËµÄmax_allowed_packetÖµ.
Ïà¹ØÎĵµ£º
ÊÔÑé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 ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
1¡¢ÈôÊÇÁ¬½Óµ½±¾»úÉϵÄMYSQL£ºÊ×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬»òÕß½«mysql\bin°²×°Â·¾¶ÉèÖÃÔÚ»·¾³±äÁ¿pathÖУ¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ± ......
Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQL ......
Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
3 rows in set (0.00 sec) ......
££¶à±í²Ù×÷
Ç°ÃæÎÒÃÇÊìϤÁËÊý¾Ý¿âºÍÊý¾Ý¿â±íµÄ»ù±¾²Ù×÷£¬ÏÖÔÚÎÒÃÇÔÙÀ´¿´¿´ÈçºÎ²Ù×÷¶à¸ö±í¡£
ÔÚÒ»¸öÊý¾Ý¿âÖУ¬¿ÉÄÜ´æÔÚ¶à¸ö±í£¬ÕâЩ±í¶¼ÊÇÏ໥¹ØÁªµÄ¡£ÎÒÃǼÌÐøÊ¹ÓÃÇ°ÃæµÄÀý×Ó¡£Ç°Ã潨Á¢µÄ±íÖаüº¬ÁËÔ±¹¤µÄһЩ»ù±¾ÐÅÏ¢£¬ÈçÐÕÃû¡¢ÐԱ𡢳öÉúÈÕÆÚ¡¢³öÉúµØ¡£ÎÒÃÇÔÙ´´½¨Ò»¸ö±í£¬¸Ã±íÓÃÓÚÃèÊöÔ± ......