SQLÎÊÌâ
SQL¾³£Óöµ½Õâ¸öÎÊÌ⣺
ϵͳ´íÎó£ºÔÚÏò·þÎñÆ÷·¢ËÍÇëÇóʱ·¢³ö´«Êä´íÎó¡££¨provider:¹²ÏíÄÚ´æÌṩ³ÌÐò£ºerror£º1-Ö´ÐжÁ/д²Ù×÷ÆÚ¼ä¼ì²âµ½I/o´íÎó¡££©
ÒÔǰ¶¼ÊÇÔÚÍâΧÉèÖÃÀïÌí¼ÓÔ¶³ÌÁ¬½Ó£¬²¢Ñ¡Ôñ¡°Í¬Ê±Ê¹ÓÃTCP/IPºÍ named pipes(b)½â¾öµÄ£¬¶ø½ñ´Î¾Í²»ÐÐÁË£¬Ï£Íû¹éÄÉÏÂÕâ¸öÎÊÌâµÄ¸ùÔ´ºÍ¾ßÌåµÄ½â¾ö·½·¨£¬Ð»Ð»~~
ÎÒÁ¬½ÓµÄÊDZ¾»úµÄ£¬http://127.1.1.0:8080ÇëÇóµÄ
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......