ÇëÎÊÓÐÒ»¸öÀàcÀïÃæÓÐÒ»¸ö¾²Ì¬±äÁ¿d
ÔÚÀàbÀïÃæÓÐÒ»¸öÀàcµÄ¶ÔÏó£¬ÔÚÀàbͨ¹ýÀàcµÄ¶ÔÏóÐÞ¸ÄÁ˾²Ì¬±äÁ¿µÄÖµ
ÏÖÔÚÇëÎÊÈç¹ûÔÚÀàaÀïÃæ·ÃÎʾ²Ì¬±äÁ¿cÊÇÄÜ·ÃÎʵ½ÐÞ¸ÄÒÔºóµÄÖµÂ𣿣¿£¿
ÏÖÔÚÇëÎÊÈç¹ûÔÚÀàaÀïÃæ·ÃÎʾ²Ì¬±äÁ¿cÊÇÄÜ·ÃÎʵ½ÐÞ¸ÄÒÔºóµÄÖµÂ𣿣¿£¿
¿ÉÒÔ£¬ÀàA£¬ÀàBºÍÀàC±ØÐëÔÚͬһjvmÖÐ
¾²Ì¬±äÁ¿ÊÇÊôÓÚÀàµÄ£¬µ÷ ......
ÎÒÔÚMYSQLÖн¨ÁËÒ»¸öÓУ¸£°¸ö×Ö¶ÎµÄ±í¡£
È»ºó²åÈëÒ»Ìõ¼Ç¼£¬¿ÉÊÇÎÞ·¨³É¹¦²åÈë¡£
ÇëÎÊÕâÊÇʲôÔÒòÄØ£¿ÓÐʲôºÃµÄ½â¾ö°ì·¨Âð£¿
ÎÒÔÚÍøÉÏËÑÁ˺ܾã¬ÓÐÒ»¸ö·½·¨ÊÇ£ºÏȲåÈëÒ»¸ö×ֶΡ£È»ºó¶ÔÕâ¸ö¼Ç¼½øÐÐUPDATE¡£
ллÁË¡£
ºÜ¼òµ¥£¬ÄãµÄÓï¾äд´íÁË¡£
Äã×Ô¼º¶¼²»°Ñ´úÂë·¢ÉÏÀ´±ðÈËÔõÏþµÃÊÇÔõô»ØÊ ......
µÃÓÃlike
ÊÇmysql
SELECT * from TB WHERE COL LIKE '%AFDA%'
ÒýÓÃ
µÃÓÃlike
ÊÇmysql
mysql?
SQL code:
²»¶®£¬°ï¶¥£¬Ñ§Ï°£¬²ä·Ö.
ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£
ÊÇÓà mysql ʵÏÖ ²éѯ Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡
ÒýÓÃ
ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£
ÊÇÓÃ m ......
id userid salesorderid
1 1 2
2 1 2
3 1 3
4 1 3 ......
select c.globalUid,c.badge,temp.sumB,temp.sumP from tb_user c,(select a.uid,sum(a.badge) as sumB,IFNULL(sum(b.propertyNum),0) as sumP,sum(a.badge)-IFNULL(sum(b.propertyNum),0) as cha from tb_buyfun_log a left join buyrecord b on a.uid=b.globaluid group by a.uid having cha>500) as temp where uptim ......
create table Employee
(
ssn INTEGER not null unique,
Name varchar(30) not null,
Address varchar(30) not null,
Age INTEGER not null,
Sex varchar(10) not null,
Position varchar(20) not null,
primary key(ssn)
)ENG ......