mysqlÖеĴÎÊý±È½ÏÎÊÌâ
ÉÏ´ÎÈ¥ÃæÊÔÓöµ½Ò»¸öÕâÑùµÄÎÊÌ⣬Çë¸÷λ´óϺ£¬½â´ðһϣº
ÓÐt_testÕâÑùÒ»¸ö±í£¬idÊÇÖ÷¼ü£¬ÏÂÃæÁ½¸öÓï¾ä·Ö±ð±È½Ï¶àÉٴΣ¨ÒýÇæÓÉ×Ô¼ºÉ趨£©
select * from t_test where id=1;
select * from t_test where id=100000000;
¶ÔÓÚÕâÑùµÄÎÊÌâÕæ²»ÖªµÀÔõôÏÂÊÖ°¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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 ......
ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î
id class(ѧÉú°à¼¶) studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®) studentName(ѧÉúÐÔÃû)
¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶,
ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......