C#ÔõôÁ¬½ÓMySql£¿
C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString("Ö÷»ú","Êý¾Ý¿â","Óû§","ÃÜÂë",¶Ë¿Ú).AsString);
Ó÷¨ºÍMSSQLÒ»Ñù
˵µÄºÃ£¬µ«ÊÇÕâºÁÎÞÒâÒå
ºÇºÇ
ÎÒÒ»Ö±¶¼ÓõÄJAVA£¬¶øÇÒÁ¬µÄÊÇORCALÊý¾Ý¿â
ºÙºÙ£¬Ñ§Ï°ÁË£¡
Òª²»¼ÌÐøÁ¬OracleÈ¥£¿
ÏÂÔØÁ¬½ÓmysqlµÄÇý¶¯£ºC# code:
http://download.csdn.net/source/1077784
°²×°ºó£¬Ìí¼ÓÒýÓãºMySql.Data.MySqlClient;
È»ºó´úÂëÖУ¬°ÑSqlConnectionµÈÀà¶¼¶ÔÓ¦µÄÓÐMySqlConnection£¬Èç¹ûÄã²»»áÁ¬sql£¬»Ø¼Ò¿´Êé
¶¥
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ
mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table   ......
¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿
@ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£
Ç°Ãæ¼Ó@´ú±í»á»° ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶
ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ
²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......