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.
¿ ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......