ûÓпÉÒÔ²éÕÒmysql Êý¾Ý¿âÀïÃæÈ«ÓÐÄÚÈݵŤ¾ß
Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,
²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß
Èç¹ûÎÒÏÂÔØÁËÒ»¸ö³ÌÐò,ËüµÄ½Å×¢FOOT ÊÇдÔÚÊý¾ÝÖеÄÈç¹ûÓÐÒ»ÖÖ¹¤¾ß¿ÉÒÔ¸ù¾Ý¹Ø¼ü×Ö
Èçij¹«Ë¾, ¿ÉÒԺܿìµÄ¼ìË÷µ½ÔÚijÕűíÖÐ,ÄǾͿÉÒÔ½ÚÊ¡ºÜ¶àʱ¼ä
ÄúµÄÐèÇóµÚÒ»´ÎÌýµ½ ²»¹ý±íÒ²ÒªÓз¶Î§
select t1.gongsi,t2.gongsi,t3.gongsi,t4.gongsi
where gongsi ="company"
ûÓÐÕâÖÖ¹¤¾ß£¬
²»¹ýÄã¿ÉÒÔ×Ô¼ºÐ´¸ö½Å±¾»òÕß´æ´¢¹ý³ÌÀ´ÊµÏÖ¡£
ͨ¹ý show tables ºÍµÄËùÓÐµÄ±í£¬È»ºóÔٵõ½Ã¿¸ö±íËùÓеÄÁС£È»ºó½øÐÐËÑË÷¡£
Õâ¸ö¹¤¾ßÂ²»ÖªµÀÓÐûÓÐÈË¿ª·¢ÁËûÓÐ(µ½Ä¿Ç°ÎªÖ¹£¬×îÉÙÎÒûÓÐÅöµ½)
ÔÀíÂ¸ù¾Ýinformation_schema¿âÀïÃæµÄ±ítablesºÍ±ícolumns£¬²ÉÓö¯Ì¬Óï¾äÑ»·É¨ÃèÊÇ¿ÉÒÔʵÏֵġ£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}
if(!mysql_real_connect(&mysql,"localhost","test" ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶
ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ
²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......
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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......