Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿
@ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£

Ç°Ãæ¼Ó@´ú±í»á»° ......

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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......

mysqlµ¼ÈëÊý¾Ý¿âÎÊÌâ

ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî
  mysql -uadmin -padmin student < d:\a.txt
ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡
mysql -uadmin -padmin st ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ