Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

javaÓйؾ²Ì¬Àà

ÇëÎÊÓÐÒ»¸öÀàcÀïÃæÓÐÒ»¸ö¾²Ì¬±äÁ¿d
ÔÚÀàbÀïÃæÓÐÒ»¸öÀàcµÄ¶ÔÏó£¬ÔÚÀàbͨ¹ýÀàcµÄ¶ÔÏóÐÞ¸ÄÁ˾²Ì¬±äÁ¿µÄÖµ
ÏÖÔÚÇëÎÊÈç¹ûÔÚÀàaÀïÃæ·ÃÎʾ²Ì¬±äÁ¿cÊÇÄÜ·ÃÎʵ½ÐÞ¸ÄÒÔºóµÄÖµÂ𣿣¿£¿
ÏÖÔÚÇëÎÊÈç¹ûÔÚÀàaÀïÃæ·ÃÎʾ²Ì¬±äÁ¿cÊÇÄÜ·ÃÎʵ½ÐÞ¸ÄÒÔºóµÄÖµÂ𣿣¿£¿
¿ÉÒÔ£¬ÀàA£¬ÀàBºÍÀàC±ØÐëÔÚͬһjvmÖÐ

¾²Ì¬±äÁ¿ÊÇÊôÓÚÀàµÄ£¬µ÷ ......

mysql²åÈë´óÁ¿×Ö¶Î

ÎÒÔÚMYSQLÖн¨ÁËÒ»¸öÓУ¸£°¸ö×Ö¶ÎµÄ±í¡£

È»ºó²åÈëÒ»Ìõ¼Ç¼£¬¿ÉÊÇÎÞ·¨³É¹¦²åÈë¡£

ÇëÎÊÕâÊÇʲôԭÒòÄØ£¿ÓÐʲôºÃµÄ½â¾ö°ì·¨Âð£¿

ÎÒÔÚÍøÉÏËÑÁ˺ܾã¬ÓÐÒ»¸ö·½·¨ÊÇ£ºÏȲåÈëÒ»¸ö×ֶΡ£È»ºó¶ÔÕâ¸ö¼Ç¼½øÐÐUPDATE¡£

ллÁË¡£
ºÜ¼òµ¥£¬ÄãµÄÓï¾äд´íÁË¡£

Äã×Ô¼º¶¼²»°Ñ´úÂë·¢ÉÏÀ´±ðÈËÔõÏþµÃÊÇÔõô»ØÊ ......

mysqlÔõôʵÏÖÄ£ºý²éѯº¬%µÄÊý¾Ý

µÃÓÃlike 
ÊÇmysql
SELECT * from TB WHERE COL LIKE '%AFDA%'

ÒýÓÃ
µÃÓÃlike 
ÊÇmysql

mysql?
SQL code:
²»¶®£¬°ï¶¥£¬Ñ§Ï°£¬²ä·Ö.

ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£

ÊÇÓà mysql  ʵÏÖ ²éѯ  Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡

ÒýÓÃ
ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£

ÊÇÓÃ m ......

ÔõÑùɾ³ýmysqlÖÐÖØ¸´µÄ¼Ç¼

id  userid  salesorderid 
  1      1        2
  2      1        2
  3      1        3
  4      1        3 ......

mysqlÎÊÌ⣬¹òÇó¸ßÊÖ½â´ð

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 ......

MYSQLÈçºÎÌí¼Ó¶à¸öÍâ¼ü£¿

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 ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2544] [2545] [2546] [2547] 2548 [2549] [2550] [2551] [2552] [2553]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ