mysql×Ô¶¯Ôö³¤µÄÎÊÌâ,ÈçºÎ»Ö¸´´Ó1¿ªÊ¼
ÔÚÒ»¸ö±íÖÐÎÒÉèÖõ½autoidΪ×Ô¶¯Ôö³¤ÁÐ
ÀýÈçÓÐÈçÏÂÊý¾Ý
1 ÕÅÈý ÄÐ 20
2 ÍõÎå ÄÐ 22
3 ÀîËÄ ÄÐ 25
4 ³Â´ó ÄÐ 19
ÏÖÔÚÎÒ°Ñ autoid=3 ºÍ autoid=4 µÄÁ½Ìõ¼Ç¼ɾ³ý
È»ºóÎÒÔÙ²åÈëÒ»ÌõÊý¾Ý,ÀýÈç:
insert into userinfo(autoid,username,sex,age) values('null','´º¸ç','ÄÐ','27');
µ«ÊÇÃæÁÙÒ»¸öÎÊÌâ,±àºÅÊÇ´Ó5¿ªÊ¼ÁË,¶ø²»ÊǽÓ×Å´Ó3¿ªÊ¼.±Ï¾¹ÎÒ µÚÈýÌõºÍµÚËÄÌõ¼Ç¼ÒѾɾ³ýµÄÁË.
ÇëÎÊÈçºÎÈÃautoid ´Ó3¿ªÊ¼,Çë¸ßÊִͽÌ.
×Ô¶¯Ôö³¤ÁÐÉèÖóɲ»×Ô¶¯µÄ
»òÕßinsert into tb values £¨3£©£»
SQL code:
mysql> select auto_increment from information_schema.tables where table_name="te
st";
+----------------+
| auto_increment |
+----------------+
| 4 |
+----------------+
1 row in set (0.02 sec)
»òÕßÉèÖÃÕâ¸öÖµ
ÎÒÖ»ÄÜ˵,Â¥ÉÏÌ«¾´ÒµµÄ
ÎÒ²»¸øËû·Ö,ÎÒ¶Ô²»Æ𵳺ÍÈËÃñ.
¾¡Á¿²»ÒªÒ»»á×ÔÔö£¬Ò»»á¸øÓè±äÁ¿¡£
»áŪÂÒÊý¾Ý¿âµÄ¡£
Äþ¿É¶Ô´íÎóµÄÊý¾Ý½øÐÐupdateÐÞÕý£¬»òÕßdelete£¬¶ø²»ÒªinsertÒ»¸ö¸úÀÏÊý¾ÝÓÐÏàͬIDµÄÐÂÊý¾Ý¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
SQL code:
--½¨Á¢ÁÙʱ±í£¬ÎÊÌâ1
create TEMPORARY table tmp_table(s1 int,s2 varchar(30))
--select * from tmp_table
--½¨Á¢ÁÙʱ±äÁ¿£¬ÎÊÌâ2
set @v=0;
--Ñ»·Ö´ÐвåÈë²Ù×÷£¬ÎÊÌâ3
while @v<20 do
......
´ó¼ÒºÃ£¡
ÎÒʹÓÃ
CommonDBUtils²Ù×÷mysqlÊý¾Ý¿â£¡
¿ÉÒÔÖ´ÐÐselectÓï¾ä£¬µ«ÊDz»ÄÜÖ´ÐÐinsertÓï¾ä
Ò»ÏÂÊÇÒì³£
java.sql.SQLException: Feature not implemented Query: insert into Computer_Ignor ......