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

ÎÊÒ»ÏÂMySQLµÄSQLÓï¾äÁ¬½ÓµÄÎÊÌâ

SQL, Óï¾ä, Á¬½Ó
ÎÊһϣºmysqlÀsqlÓï¾ä¿ÉÒÔÁ¬ÔÚÒ»Æð£¬ÐÎÈ磺
$sql="Óï¾ä1; Óï¾ä2; Óï¾ä3";
ÎÊһϣ¬Õâ¸öqueryÊDz»ÊÇÒ²ÊÇÒ»¸ö¡°ÊÂÎñ¡±£¬ÒªÃ´È«²¿Ö´ÐУ¬ÒªÃ´È«²¿²»Ö´ÐУ¿

²»Êǵ쬳ý·ÇÄãÏÔʽµÄ¿ªÊ¼Ò»¸öÊÂÎ·ñÔòÿִÐÐÒ»ÌõSQL£¬¶¼×Ô¶¯Ìá½»Ò»´ÎµÄ¡£

ÄÇ£ºÒ»ÌõSQLÓï¾äÊDz»ÊÇ×Ô¶¯µÄ±»¶¨Òå³ÉÒ»¸ö¡°ÊÂÎñ¡±£¬¾ÍÊÇ˵£¬Ò»ÌõSQLÓï¾ä²»¿ÉÄÜÖ´ÐÐÁ˰ëÀ­×Ó£¬»¹ÓеÄ×Ö¶Îû²Ù×÷ÄØ£¬¾ÍÍ£Ö¹ÁË£¿Î¢ÈíµÄms-sqlserver ºÍ access ¿ÉÊÇÕâÑùµÄ¡£

ÒýÓÃ
ÄÇ£ºÒ»ÌõSQLÓï¾äÊDz»ÊÇ×Ô¶¯µÄ±»¶¨Òå³ÉÒ»¸ö¡°ÊÂÎñ¡±£¬¾ÍÊÇ˵£¬Ò»ÌõSQLÓï¾ä²»¿ÉÄÜÖ´ÐÐÁ˰ëÀ­×Ó£¬»¹ÓеÄ×Ö¶Îû²Ù×÷ÄØ£¬¾ÍÍ£Ö¹ÁË£¿Î¢ÈíµÄms-sqlserver ºÍ access ¿ÉÊÇÕâÑùµÄ¡£


ÎÒ¾õµÃÓ¦¸ÃÊÇ¿ÉÒÔÕâôÀí½âµÄ¡£

²»ÊÇµÄ ¿ÉÄÜÖ»Ö´ÐÐÒ»²¿·Ö Óöµ½±¨´íÌø³ö

Äã¿ÉÒÔÕâôÀí½â£¬°Ñ¶àÌõÓï¾äÁ¬½Óµ½Ò»Æð£¬¾ÍÏ൱ÓÚÒ»¸öÅú´¦Àí£¬ÒòΪÊÇ×Ô¶¯Ìá½»ÊÂÎïµÄ£¬ËùÒÔ¾ÍÖ´ÐÐÒ»ÌõÌá½»Ò»Ìõ¡£


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ