mysql ¼òµ¥ÎÊÌâ
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 ϵͳʱ¼ä
3 nike 2000 ϵͳʱ¼ä
ÏÖÔÚÎÒÏëʵÏÖ´ÓÊý¾Ý¿âÖмìË÷³önameΪnikeµÄ¼Ç¼£¬¼õÈ¥500£¬½á¹ûΪ
1 nike 0 ϵͳʱ¼ä
2 nike 0 ϵͳʱ¼ä
3 nike 1900 ϵͳʱ¼ä
ÔÚÊý¾Ý¿â¶Î¸ÃÈçºÎʵÏÖ£¿
SQL code:
select
id,
name,
IF(
((select sum(num) from test where name='nike' and rtime<=t.rtime)-500)<0,
0,
(select sum(num) from test where name='nike' and rtime<=t.rtime)-500
)
rtime
from
test t
where
name='nike'
SQL code:
--2Â¥Õý½â£¬Ã»»°Ëµ£¬Ò»¸ö×Ö£º¶¥£¡
SQL code:
mysql> select * from test;
+------+------+------+---------------------+
| id | name |
Ïà¹ØÎÊ´ð£º
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇΪʲôÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
´ó¼ÒºÃ£¡
ÎÒʹÓÃ
CommonDBUtils²Ù×÷mysqlÊý¾Ý¿â£¡
¿ÉÒÔÖ´ÐÐselectÓï¾ä£¬µ«ÊDz»ÄÜÖ´ÐÐinsertÓï¾ä
Ò»ÏÂÊÇÒì³£
java.sql.SQLException: Feature not implemented Query: insert into Computer_Ignor ......
ÔÚÒ»¸ö±íÖÐÎÒÉèÖõ½autoidΪ×Ô¶¯Ôö³¤ÁÐ
ÀýÈçÓÐÈçÏÂÊý¾Ý
1 ÕÅÈý ÄÐ 20
2 ÍõÎå ÄÐ 22
3 ÀîËÄ ÄÐ 25
4 ³Â´ó ÄÐ 19
ÏÖÔÚÎÒ°Ñ autoid=3 ºÍ autoid=4 µÄÁ½Ìõ¼Ç¼ɾ³ý
È»ºóÎÒÔÙ²åÈëÒ»ÌõÊý¾Ý,À ......
Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êý駿âÖвéÑ°ËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,
²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß
û¿´¶®ÄãдµÄ
ÍƼö¸ö
MySQLQueryBrowser
phpMyAdmin£¬MySQL GU ......