mysqlÊý¾ÝÀàÐ͵ÄÎÊÌâ
ÎÊÏ£¬mysqlÖÐÓÐûÓÐlistÊý¾ÝÀàÐͰ¡£¿
ENUMÀàÐÍ
or
CREATE TABLE dd1(ee SET('1','2','3'))
Èç¹ûÏëÒªÍêÈ«ÏñlistÄÇÑùµÄÀàÐÍ£¬ÔÚÊý¾Ý¿âϵͳÀïÃæÄ¿Ç°¶¼Ã»ÓеÄ
Ò»°ãÇé¿öÏ£¬list϶¼ÊÇÏÔʾ²¿·Ö»òÈ«²¿¼Ç¼µÄ
ÔÚÊý¾Ý¿âÏ£¬Äã¿ÉÒÔÕâÑù´¦Àí£ºµ¥¶ÀÉè¼ÆÒ»Õűí,È»ºóʹÓÃÍâ¼üÔ¼Êø°Ñ¼Ç¼ºÍËùÊô¶ÔÏó¹ØÁªÆðÀ´
²»ÖªµÀÔõôʹÓÃ
Êǹ«Ë¾ÀÏÍâÉè¼ÆµÄÊý¾Ý¿â
¿´²»Ì«¶®
ÎÒÈ¥ÎÊÎÊËû±¾È˺ÃÁË
µÈϽӷָøÄã
±§Ç¸ ÉÙ¸øÁËÒ»¸öÈË
ÎÒ¿´´íÁË
һλֻÓÐÈý¸öÈË
²»ºÃÒâ˼
Ïò wwwwb µÀǸ
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......