ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
ΪÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u root -p mydatabaseÀ´µÇ¼mysql¡£µÇ¼ºó£¬ÔÚmysqlÌáʾ·ûÏ£¬Ê¹ÓÃsourceÃüÁîÈçsource D:/sql/test.sqlÖ´ÐÐsqlÓï¾ä¡£
ÁíÍ⣬Çл»Êý¾Ý¿âµÄÃüÁîΪuse£¬Èçuse mydatabase;
Ïà¹ØÎĵµ£º
½øÈëcmd
===================
1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......
Ò»¡¢´ÓÄÄÀïÈëÊÖ
µ±Ò»Ì¨MYSQL·þÎñÆ÷´î½¨Íê³É²¢¿ÉÒÔÕý³£ÔËÐÐʱ£¬ÊDz»ÊÇÎÒÃǵĽŲ½¾ÍÍ£Ö¹ÁË£¬×ÔÒÔΪ¿ÉÒÔ¿ªÊ¼Ê¹ÓÃÁË£¬¶ÔרҵÈËÊ¿À´ËµÆäʵ»¹ÐèÒª¸ü¶àµÄÏà¹ØÓÅ»¯ºÍÉèÖá£ÔõôȥÓÅ»¯£¿ÔõôȥÉèÖã¿Ê×ÏÈÎÒÃǵÃÕÒµ½ËüµÄÆ¿¾±£¬ÎÒÏÖÔÚËùÁ˽âµÄÓÐÁ½ÖÖ·½·¨£¬Ò»ÊÇ»ù×¼²âÊÔ£¬¶þ¾ÍÊdzÌÐò·ÖÎö£¬ËûÃÇÓÐ×ÅÃÜÇеÄÁªÏµ ......
¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION fc_is_hanzi(
p_str VARCHAR(1024)
)
......
Private Sub insert1_click()
Dim iCount As Integer
Dim cn
Set cn = CreateObject("ADODB.Connection")
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=8233;Initial Catalog=hskmis;Data Source=127.0.0.1"
cn.Open
cn.Execute ("delete temp9")
'¼ÆËã¸Ã±íÓжàÉÙÐ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......