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£¬»Ø¼Ò¿´Êé ¶¥
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ public static final DataBase.MAXSIZE=102 ......
¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿ @ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£ Ç°Ãæ¼Ó@´ú±í»á»° ......
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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî mysql -uadmin -padmin student < d:\a.txt ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡ mysql -uadmin -padmin st ......