Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Îʸömysql¶à±í²éѯµÄÅÅÐòÎÊÌâ

Óï¾äÊÇÕâÑùµÄ
SELECT jingbiao_yb1,zhaobiaoadd_id,zhaobiaoadd_title,jingbiao_time,zhaobiao_time,zhaobiao_zhuangtai from `zhaobiaoadd` left join(jingbiao) on (zhaobiaoadd.zhaobiaoadd_id=jingbiao.zhaobiao_id) where zhaobiaoadd.zhaobiaoadd_title like '%»¢È¨%' group by jingbiao.zhaobiao_id order by jingbiao.jingbiao_time desc;
µ«ÊDzé³öÀ´µÄ½á¹û²¢²»ÊÇÎÒÏëÒªµÄÅÅÐò ÏÖÔڵĽá¹ûÊÇ jingbiao ²é³öÀ´µÄ½á¹ûÒ»´ó¶ÑÖØ¸´ÎÒÓÃgroup by Ö®ºóŪ³öÀ´µÄ½á¹ûËäȻûÓÐÖØ¸´Á˵«ÊÇ ³öÀ´µÄʱ¼ä²¢²»ÊÇÎÒÏëÒªµÄÎÒÏëÒª¾º±ê±íÀïÍ·µÄʱ¼äÅÅÐòµÄ×îºóÒ»¸ö½á¹ûµ«ÊÇÏÖÔÚÊÇ
µÚÒ»¸ö½á¹û
ÄãµÄÅÅÐò×Ö¶ÎÊÇ jingbiao.jingbiao_time ,¿´¿´ÊDz»ÊǸã´íÁË~

ûÓдí


Äã²éѯtime×î´óµÄʱ¼ä ²»ÐèÒª·Ö×é°¢.

¿ÉÒÔÊÔÊÔmaxº¯Êý.

ÄãÔÚselectµÄʱºòÃ²ËÆÃ»Ö¸Ã÷ÊÇÄĸö±íÀïµÄ×Ö¶ÎŶ£¬Êý¾Ý¿âĬÈϻὫËùÓбíÀïÆ¥ÅäµÄ×ֶεÄÖµÁгöÀ´£¬×ÔÈ»¾Í»áÓÐÖØ¸´ÁË£¬ÒªÏëÅÅÐò»¹µÃ¼Ó¸öorder by Óï¾ä£¬²»È»»¹Êǰ´·Ö×éÅÅÐòµØ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÈçºÎÓÃMFCÁ¬½ÓÉÏMYSQL - VC/MFC / Êý¾Ý¿â

ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл

°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã

ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°


mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡

ÌùÓÊÏ䣬·¢Äã

1.mysql api
2.myodbc
......

MySql Hibernate ²éѯÓï¾äÎÊÌâ - Java / Java EE


hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐР
 µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
  ÕâÊÇʲôÎÊÌ⣡£¡£¡

ÎÒÒѾ­ÖªµÀÁË£¡
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ