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

c# Á¬½ÓMySqlÊý¾Ý¿âµÄÁ½ÖÖ·½·¨

1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ

MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
 
using

System;
using

System.Collections.Generic;
using

System.ComponentModel;
using

System.Data;
using

System.Data.Odbc;
using

System.Drawing;
using

System.Linq;
using

System.Text;
using

System.Windows.Forms;
using

MySQLDriverCS;
 
 
namespace

mysql
{
    public
partial
class
Form1
: Form
    {
        public
Form1()
        {
           
InitializeComponent();
        }
 
        private
void
Form1_Load(object
sender, EventArgs
e)
        {
 
           
MySQLConnection
conn = null
;
           
conn = new
MySQLConnection
(new
MySQLConnectionString
("localhost"
, "inv"
, "root"
, "831025"
).AsString);
           
conn.Open();
 
           
MySQLCommand
commn = new
MySQLCommand
("set names gb2312"
, conn);
           
commn.ExecuteNonQuery();
 
           
string
sql = "select * from exchange "
;
           
MySQLDataAdapter
mda =


Ïà¹ØÎĵµ£º

ASP.NETÓëMySqlµÄÁ¬½Ó

1.Êý¾ÝÁ¬½Ó·½Ê½
ASP.NET±¾ÉíµÄÊý¾Ý·ÃÎÊADO.NET²»Ö§³Ö¶ÔÓÚMySqlµÄÁ¬½ÓºÍ²éѯ£¬µ«ÊÇMySQL¹ÙÍøÉϾùÌṩÁ˶àÖÖASP.NETÁ¬½Óµ½MySQLµÄ·½Ê½£º
£¨1£©ODBCÇý¶¯µÄ·ÃÎÊ·½Ê½£ºmysql-connector-odbc-5.1.5-win32.msi£¬ODBC
£¨2£©ADO.NET¶ÔÓÚMySQLµÄ·ÃÎÊ·½Ê½£ºmysql-connector-net-6.2.2.zip
¸öÈËÑ¡ÓõÄÊǵڶþÖÖ£¬¸Ð¾õ·½±ã£¬ºÍ.NET¶ÔS ......

mysql´æ´¢¹ý³Ì»ù±¾º¯Êý


Ò».×Ö·û´®Àà 
CHARSET(str) //·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2  [,... ]) //Á¬½Ó×Ö´®
INSTR (string ,substring ) //·µ»ØsubstringÊ×´ÎÔÚstringÖгöÏÖµÄλÖÃ,²»´æÔÚ·µ»Ø0
LCASE (string2 ) //ת»»³ÉСд
LEFT (string2 ,length ) //´Óstring2ÖеÄ×ó±ßÆðÈ¡length¸ö×Ö·û
LENGTH (string ) //string³¤¶È
LO ......

fedora11 Ï mysql Ô´Âë°²×°¹ý³Ì


»·¾³:
  fedora11 , mysql5.1.34Ô´Âë°²×°£º
  
  ×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»Ê ......

MYsql ÒìµØ±¸·Ý½Å±¾

ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
 
±ÈÈçÎļþà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ