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

mysql ²éѯÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

mysqL Óï¾ä£ºselect examlist_name as name,from_UNIXTIME(examlist_kaoshiriqi,'%Y-%m-%d') as kaoshiriqi,from_unixtime(examlist_baomingriqi '%Y-%m-%d') as baomingriqi,examlist_belong as belong from dede_examlist where examlist_kaoshiriqi>unix_timestamp()£»
²éѯµÄ½á¹ûΪ£º

name kaoshiriqi baomingriqi belong

µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-14 zq
µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-14 zq
µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-15 zq
µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-15 zq
µÚ¶þ´Î¿¼ÊÔ 2010-06-25 2010-06-01 zq
µÚ¶þ´Î¿¼ÊÔ 2010-06-26 2010-06-01 zq
µÚÈý´Î¿¼ÊÔ 2010-06-24 2010-06-18 zq
µÚÈý´Î¿¼ÊÔ 2010-06-26 2010-06-18 zq
µÚËĴο¼ÊÔ 2010-06-25 2010-06-19 zq
µÚËĴο¼ÊÔ 2010-06-26 2010-06-19 zq
µÚÎå´Î¿¼ÊÔ 2010-06-24 2010-06-12 zq
µÚÎå´Î¿¼ÊÔ 2010-06-25 2010-06-12 zq
µÚÎå´Î¿¼ÊÔ 2010-06-17 2010-06-10 zq
µÚÎå´Î¿¼ÊÔ 2010-06-18 2010-06-10 zq
µÚ°Ë´Î֤ȯ¿¼ÊÔ 2010-06-22 2010-06-12 zq
µÚ°Ë´Î֤ȯ¿¼ÊÔ 2010-06-22 2010-06-13 zq
µÚ¾Å´Î¿¼ÊÔ 2010-10-11 2010-10-05 zq
µÚÒ»´ÎÒøÐп¼ÊÔ 2010-07-12 2010-07-11 yh
µÚ¶þ´ÎÒøÐп¼ÊÔ 2010-07-22 2010-07-20 yh
Õâ¸ö²éѯµÄ½á¹û£¬ÎÒÏë°Ñname ÖµÏàͬµÄ¼Ç¼£¬ºÏ²¢³ÉÒ»Ìõ¼Ç¼£¬mysql Óï¾ä¿ÉÒÔʵÏÖÂð£¿

ÒýÓÃname kaoshiriqi baomingriqi belong

µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-14 zq
µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-14 zq
µÚÒ»´Î֤ȯ¿¼ÊÔ 2


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

myeclipse+mysqlµÄÅäÖÃÎÊÌâ - Java / Eclipse

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......

MySQLÊý¾Ý¿â´æ·ÅÔÚÄİ¡£¿ - MS-SQL Server / »ù´¡Àà

ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡
ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir


2¡¢½øÈëmysqlÖÕ¶Ë£º
mysql>show variables like '%datadir%';

ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ