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

mysqlÊý¾ÝÀàÐ͵ÄÎÊÌâ

ÎÊÏ£¬mysqlÖÐÓÐûÓÐlistÊý¾ÝÀàÐͰ¡£¿

ENUMÀàÐÍ


or
CREATE TABLE dd1(ee SET('1','2','3'))

Èç¹ûÏëÒªÍêÈ«ÏñlistÄÇÑùµÄÀàÐÍ£¬ÔÚÊý¾Ý¿âϵͳÀïÃæÄ¿Ç°¶¼Ã»ÓеÄ

Ò»°ãÇé¿öÏ£¬list϶¼ÊÇÏÔʾ²¿·Ö»òÈ«²¿¼Ç¼µÄ

ÔÚÊý¾Ý¿âÏ£¬Äã¿ÉÒÔÕâÑù´¦Àí£ºµ¥¶ÀÉè¼ÆÒ»Õűí,È»ºóʹÓÃÍâ¼üÔ¼Êø°Ñ¼Ç¼ºÍËùÊô¶ÔÏó¹ØÁªÆðÀ´

²»ÖªµÀÔõôʹÓÃ
Êǹ«Ë¾ÀÏÍâÉè¼ÆµÄÊý¾Ý¿â
¿´²»Ì«¶®
ÎÒÈ¥ÎÊÎÊËû±¾È˺ÃÁË
µÈϽӷָøÄã


±§Ç¸ ÉÙ¸øÁËÒ»¸öÈË
ÎÒ¿´´íÁË
һλֻÓÐÈý¸öÈË
²»ºÃÒâ˼

Ïò wwwwb µÀǸ


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ

ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦Óþ­Ñ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ