ûÓпÉÒÔ²éÕÒmysql Êý¾Ý¿âÀïÃæÈ«ÓÐÄÚÈݵŤ¾ß
Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,
²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß
Èç¹ûÎÒÏÂÔØÁËÒ»¸ö³ÌÐò,ËüµÄ½Å×¢FOOT ÊÇдÔÚÊý¾ÝÖеÄÈç¹ûÓÐÒ»ÖÖ¹¤¾ß¿ÉÒÔ¸ù¾Ý¹Ø¼ü×Ö
Èçij¹«Ë¾, ¿ÉÒԺܿìµÄ¼ìË÷µ½ÔÚijÕűíÖÐ,ÄǾͿÉÒÔ½ÚÊ¡ºÜ¶àʱ¼ä
ÄúµÄÐèÇóµÚÒ»´ÎÌýµ½ ²»¹ý±íÒ²ÒªÓз¶Î§
select t1.gongsi,t2.gongsi,t3.gongsi,t4.gongsi
where gongsi ="company"
ûÓÐÕâÖÖ¹¤¾ß£¬
²»¹ýÄã¿ÉÒÔ×Ô¼ºÐ´¸ö½Å±¾»òÕß´æ´¢¹ý³ÌÀ´ÊµÏÖ¡£
ͨ¹ý show tables ºÍµÄËùÓÐµÄ±í£¬È»ºóÔٵõ½Ã¿¸ö±íËùÓеÄÁС£È»ºó½øÐÐËÑË÷¡£
Õâ¸ö¹¤¾ßÂ²»ÖªµÀÓÐûÓÐÈË¿ª·¢ÁËûÓÐ(µ½Ä¿Ç°ÎªÖ¹£¬×îÉÙÎÒûÓÐÅöµ½)
ÔÀíÂ¸ù¾Ýinformation_schema¿âÀïÃæµÄ±ítablesºÍ±ícolumns£¬²ÉÓö¯Ì¬Óï¾äÑ»·É¨ÃèÊÇ¿ÉÒÔʵÏֵġ£
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô
create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
&nb ......