ÎÒʹÓÃµÄ MySQL Connector/NET 6.1.3 Ö´ÐÐÒ»¸ö´æ´¢¹ý³Ì£¬Õâ¸ö´æ´¢¹ý³ÌºÜ¼òµ¥£¬¾ÍÁ½¸öInsertÓï¾ä£¬·Ö±ð°ÑÍⲿ´«ÈëµÄ²ÎÊý²åÈëµ½Á½¸ö±íÖС£
½á¹ûÊý¾ÝÊÇ²å½øÈ¥ÁË£¬µ«ÊDzåÈëµÄÊý¾Ý£¬È´Ã»ÓжÔÓ¦Ö¸¶¨µÄÁУ¬Âé·³´ ......
ÎÒÔÚphpmyadminϵã»÷Ò»¸ö±íʱ³öÏÖ£º
´íÎó
SQL ²éѯ:
SHOW INDEX from `dcr_news` ;
MySQL ·µ»Ø£º
#1146 - Table 'tuiguang.dcr_news' doesn't exist
Õâ¸ö±íÊÇinnodb ÎÒÔÚ±¾µØÊý¾ÝÎļþÏÂÓУºdcr_news.frm
Ϊʲô»á³öÏÖÕâÑù..
ÎÒÔÙcreate table dcr_n ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "123456");
driver Äܵõ½£¬connect²»³É¹¦£¬con Ö¸ÕëµÄÖµÊÇ0xcccccccc,ÓÃc apiȴûÎÊÌ⣬╮(╯& ......
mysql×°ÔÚwindows2003ÏÂ×öÊý¾Ý¿â·þÎñÆ÷.ÏÖÔÚ¿ª·¢ÓÃlinuxϵijÌÐòÈ¥Á¬½ÓwindowsϵÄmysql,ËٶȺÜÂý.
¶øÁ¬½Ó±¾»úlinuxϵÄmysql(һģһÑùµÄÊý¾Ý¿â½á¹¹)È´ËÙ¶ÈÕý³£.
×¢Òâ:ÄÚÍøÁ¬½Ó,ÎÊÌâÖ÷Òª·¢ÉúÔÚmysql_real_connectµÄʱºò.
²»ÖªµÀΪʲô ,Çë´óϺÃǸøÐ©½¨Òé,лл!
ping һϣ¬Ïȼì²éÒ»ÏÂÍøÂçÉÏËÙ¶ÈÈ ......
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯,È»ºóÑ»·²åÈëmssql¾Í¿ÉÒÔÁË, mysqlÓÐado.netµÄÇý¶¯
2. »òÕßÓÃODBCÊý¾ÝÔ´, ÔÚmssqlÆóÒµ¹ÜÀíÆ÷ÉÏÊÖ¹¤µ¼Èë
......
·¢Õâ¸öÌû×ӺܾÀ½á£¬ÒòΪÂŲ̂ÉÏÓкöàÕâÖÖÎÊÌâµÄÃèÊöºÍ½â¾ö·½·¨£¬µ«ÎÒÒ»Ò»ÊÔ¹ý¾ÍÊDz»ÐУ¬ÏÖ°ÑÎÊÌâÃèÊöÈçÏ£ºÒÀACMAIN_CHMÔÚhttp://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspxÖеÄÃèÊö£¬°Ñ¸ÄÌùµÄÌùÏ£º
SQL code:
mysql> show create table t_devicegroups;
+----------------+------------------ ......