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

ûÓпÉÒÔ²éÕÒmysql Êý¾Ý¿âÀïÃæÈ«ÓÐÄÚÈݵŤ¾ß

Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,


²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß


Èç¹ûÎÒÏÂÔØÁËÒ»¸ö³ÌÐò,ËüµÄ½Å×¢FOOT ÊÇдÔÚÊý¾ÝÖеÄÈç¹ûÓÐÒ»ÖÖ¹¤¾ß¿ÉÒÔ¸ù¾Ý¹Ø¼ü×Ö
Èçij¹«Ë¾,  ¿ÉÒԺܿìµÄ¼ìË÷µ½ÔÚijÕűíÖÐ,ÄǾͿÉÒÔ½ÚÊ¡ºÜ¶àʱ¼ä
ÄúµÄÐèÇóµÚÒ»´ÎÌýµ½ ²»¹ý±íÒ²ÒªÓз¶Î§

select t1.gongsi,t2.gongsi,t3.gongsi,t4.gongsi
where gongsi ="company"

ûÓÐÕâÖÖ¹¤¾ß£¬
²»¹ýÄã¿ÉÒÔ×Ô¼ºÐ´¸ö½Å±¾»òÕß´æ´¢¹ý³ÌÀ´ÊµÏÖ¡£

ͨ¹ý show tables ºÍµÄËùÓÐµÄ±í£¬È»ºóÔٵõ½Ã¿¸ö±íËùÓеÄÁС£È»ºó½øÐÐËÑË÷¡£

Õâ¸ö¹¤¾ßÂ²»ÖªµÀÓÐûÓÐÈË¿ª·¢ÁËûÓÐ(µ½Ä¿Ç°ÎªÖ¹£¬×îÉÙÎÒûÓÐÅöµ½)
Ô­ÀíÂ¸ù¾Ýinformation_schema¿âÀïÃæµÄ±ítablesºÍ±ícolumns£¬²ÉÓö¯Ì¬Óï¾äÑ­»·É¨ÃèÊÇ¿ÉÒÔʵÏֵġ£


Ïà¹ØÎÊ´ð£º

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

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

´óÏÀÃǾÈÃü°¡:MysqlµÄmy.iniÎļþ¸ü¸ÄÊý¾Ý¿â·¾¶ÎÊÌâ

  ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à:
#Path to the database root
datadir="E ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

C#ÔõôÁ¬½ÓMySql£¿

C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
    &nb ......

½ô¼±ÇóÖú£ºmysql´´½¨Ë÷Òý³öÎÊÌâÁË

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex.s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ