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 =
Ïà¹ØÎĵµ£º
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 ......
Ò».×Ö·û´®Àà
CHARSET(str) //·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2 [,... ]) //Á¬½Ó×Ö´®
INSTR (string ,substring ) //·µ»ØsubstringÊ×´ÎÔÚstringÖгöÏÖµÄλÖÃ,²»´æÔÚ·µ»Ø0
LCASE (string2 ) //ת»»³ÉСд
LEFT (string2 ,length ) //´Óstring2ÖеÄ×ó±ßÆðÈ¡length¸ö×Ö·û
LENGTH (string ) //string³¤¶È
LO ......
»·¾³:
fedora11 , mysql5.1.34Ô´Âë°²×°£º
×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»Ê ......
ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
±ÈÈçÎļþà ......