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

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

C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
      DBConn = new MySQLConnection(new MySQLConnectionString("Ö÷»ú","Êý¾Ý¿â","Óû§","ÃÜÂë",¶Ë¿Ú).AsString);


Ó÷¨ºÍMSSQLÒ»Ñù

ÒýÓÃ
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
      DBConn = new MySQLConnection(new MySQLConnectionString("Ö÷»ú","Êý¾Ý¿â","Óû§","ÃÜÂë",¶Ë¿Ú).AsString);



˵µÄºÃ£¬µ«ÊÇÕâºÁÎÞÒâÒå
ºÇºÇ

ÎÒÒ»Ö±¶¼ÓõÄJAVA£¬¶øÇÒÁ¬µÄÊÇORCALÊý¾Ý¿â

ºÙºÙ£¬Ñ§Ï°ÁË£¡

ÒýÓÃ

˵µÄºÃ£¬µ«ÊÇÕâºÁÎÞÒâÒå
ºÇºÇ

ÒýÓÃ
ÎÒÒ»Ö±¶¼ÓõÄJAVA£¬¶øÇÒÁ¬µÄÊÇORCALÊý¾Ý¿â

Òª²»¼ÌÐøÁ¬OracleÈ¥£¿

ÏÂÔØÁ¬½ÓmysqlµÄÇý¶¯£ºC# code:
http://download.csdn.net/source/1077784

°²×°ºó£¬Ìí¼ÓÒýÓãºMySql.Data.MySqlClient;

È»ºó´úÂëÖУ¬°ÑSqlConnectionµÈÀà¶¼¶ÔÓ¦µÄÓÐMySqlConnection£¬Èç¹ûÄã²»»áÁ¬sql£¬»Ø¼Ò¿´Êé

¶¥


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

mysqlÖÐ repair table

ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ

mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table        ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

oracle ¶ÔÓ¦µÄMySQLµÄÓï¾ä

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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ