MySQLÊý¾Ýµ¼ÈëÓëµ¼³ö
¡¡ÏÖÔÚʹÓÃMySQLµÄÔ½À´Ô½¶àÁË£¬ÎÒÒ²ÓÃËü×öÁË×ÔÒѵÄÁôÑÔ°å¡£ÔÚʹÓùý³ÌÖУ¬
ÂýÂýµØ
¾ÍÒªÇó¶ÔËüµÄ¹ÜÀí
¹¦ÄÜÐèÒª½üÒ»²½µÄÕÆÎÕ£¬²»½öÊÇÎÒ£¬Ò²ÊǺܶàÍøÓѵÄÒªÇó¡£ÏÖÔÚÓÐһЩÎÊÌâÊǹØ
ÓÚÈçºÎ
´ÓMySQLÖе¼³öÊý¾Ý£¬
ÒÔ±ãÓÃÔÚ±¾µØ»òÆäËüµÄÊý¾Ý¿âϵͳ֮ÉÏ£»ÒÔ¼°½«ÏÖÓÐÊý¾Ýµ¼ÈëMySQLÊý¾Ý¿âÖС£ÏÖ
ÔÚ¾ÍÎÒ
ѧϰµÄÇé¿ö£¬¾ÍÕâ
Á½¸öÎÊÌâ×÷Ò»ÏÂС½á£¬ÄÚÈݲ»ÊǺÜÏêϸ¡£ÆäʵMySQLµÄÊÖ²áÊǺÜÏêϸµÄ£¬Ö»²»¹ýÎÒ
°ÑÓйØ
ÕâÁ½·½ÃæµÄ¶«Î÷Ìá
È¡³öÀ´£¬¼ÓÉÏÁËÒ»µã×ÔÒѵÄÀí½â£¬¸üÏêϸµÄÇë²Î¿¼Êý¾Ý¿âµÄÏàÓ¦Õ½ڡ£
Êý¾Ýµ¼³ö
¡¡¡¡Êý¾Ýµ¼³öÖ÷ÒªÓÐÒÔϼ¸ÖÖ·½·¨£º
ʹÓÃselect into outfile 'filename'Óï¾ä
ʹÓÃmysqldumpʵÓóÌÐò
ʹÓÃselect into outfile 'filename'Óï¾ä
¡¡¡¡¿ÉÒÔÔÚmysqlµÄÃüÁîÐÐÏ»òÔÚphp³ÌÐòÖÐÖ´ÐÐËü¡£ÎÒÏÂÃæÒÔÔÚmysqlÃüÁîÐÐÏÂΪ
Àý¡£ÔÚ
phpÖÐʹÓÃʱ£¬½«Æä
¸Ä³ÉÏàÓ¦µÄ²éѯ½øÐд¦Àí¼´¿É¡£²»¹ýÔÚʹÓÃÕâ¸öÃüÁîʱ£¬ÒªÇóÓû§ÓµÓÐfileµÄȨ
ÏÞ¡£Èç
ÎÒÃÇÓÐÒ»¸ö¿âΪ
phptest£¬ÆäÖÐÓÐÒ»¸ö±íΪdriver¡£ÏÖÔÚÒª°Ñdriverж³ÉÎļþ¡£Ö´ÐÐÃüÁ
mysql> use phptest;
Database Changed
mysql> select * from driver into outfile 'a.txt';
Query OK, 22 rows affected (0.05 sec)
¡¡¡¡ÉÏÃæ¾Í¿ÉÒÔÍê³É½«±ídriver´ÓÊý¾Ý¿âÖÐжµ½a.txtÎļþÖС£×¢ÒâÎļþÃûÒª¼Óµ¥
ÒýºÅ¡£
ÄÇôÕâ¸öÎļþÔÚÄÄ
ÄØ£¿ÔÚmysqlĿ¼ÏÂÓÐÒ»¸ödataĿ¼£¬Ëü¼´ÊÇÊý¾Ý¿âÎļþËù·ÅµÄµØ·½¡£Ã¿¸ö¿âÔÚµ¥
¶ÀÕ¼Ò»
¸ö×ÓĿ¼£¬ËùÒÔ
phptestµÄĿ¼Ϊc:\mysql\data\phptest(×¢Ò⣺ÎÒµÄmysql°²×°ÔÚc:\mysqlÏÂ)¡£
ºÃ£¬ÏÖ
ÔÚÎÒÃǽøÈ¥£¬a.txt
¾ÍÊÇËü¡£´ò¿ªÕâ¸öÎļþ£¬¿ÉÄÜÊÇ£º
1 Mika Hakinnen 1
2 David Coulthard 1
3 Michael Schumacher 2
4 Rubens Barrichello 2
...
¡¡¡¡¿ÉÄÜ»¹Óкܶà¼Ç¼¡£Ã¿¸ö×Ö¶ÎÖ®¼äÊÇÓÃÖƱí·û·Ö¿ªµÄ(\t)¡£ÄÇôÎÒÃÇ¿ÉÒÔÐÞ
¸ÄÊä³ö
ÎļþÃûµÄĿ¼£¬ÒÔ±ã
·ÅÔÚÖ¸¶¨µÄλÖá£Èç'a.t
Ïà¹ØÎĵµ£º
֮ǰװ¹ýÒ»±é MySQL 5.1£¬Í¬ÑùµÄ msi °²×°Îļþ£¬Ð¶ÔØ MySQL Ö®ºó¹ý¼¸ÌìÖØÐÂ×°È´Ôõô¶¼²»ÐС£
°²×°ºÃÁËÖ®ºóÅäÖà MySQL ʵÀýµÄʱºòµ½µÚÈý²½“Start Service”Ôõô¶¼¹ý²»È¥£¬³¢ÊÔ×Ô¼ºÆô¶¯·þÎñ»òÕßÓÃÃüÁîÐÐÆô¶¯£¬¶¼Ê§°Ü£»ÉÏÍøÕÒÁËһϣ¬±ðÈËÒ»°ã¶¼Ëµ my.ini ÓÐÎÊÌ⣬³¢ÊÔÁËÒ²²»¹ÜÓá£
ÔÙ´ÎÖØ×°µÄʱºò£¬ÎÞÒâÖп´¼ûÓÐ ......
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ʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
//×°ÔØmysql-jdbcÇý¶¯
Class.forName("com.mysql.jdbc.Driver" ......
Êý¾Ý²Ö¿âÖ®¸¸Bill InmonÔÚ1991Äê³ö°æµÄ“Building the Data
Warehouse”Ò»ÊéÖÐËùÌá³öµÄ¶¨Òå±»¹ã·º½ÓÊÜ——Êý¾Ý²Ö¿â£¨Data Warehouse£©ÊÇÒ»¸öÃæÏòÖ÷ÌâµÄ£¨Subject
Oriented£©¡¢¼¯³ÉµÄ£¨Integrated£©¡¢Ïà¶ÔÎȶ¨µÄ£¨Non-Volatile£©¡¢·´Ó³ÀúÊ·±ä»¯£¨Time
Variant£©µÄÊý¾Ý¼¯ºÏ£¬ÓÃÓÚÖ§³Ö¹ÜÀí¾ö²ß(D ......
Á¬Ðø¼¸Ìì°²×°ÅäÖúÍÁ¬½ÓMysqlÊý¾Ý¿â£¬½ñÌìÖÕÓڳɹ¦ÁË£¬»ØÏëÕ⼸Ì죬ÕæµÄÊÇÌðËá¿àÀ±¶¼ÓУ¬µ¥mysql¾ÍÖØ×°Á˲»ÏÂ10´Î£¬¶øÔÚeclipseÉϱàдµÄÁ¬½ÓÊý¾Ý¿âµÄ³ÌÐò×ÜÊDZ¨´í£®ÎÒ¶¼ÒѾdownÁËoracal×¼±¸·ÅÆúmysqlÁË£¬²»¹ý£®£®£®¾ÍÏóµçÊÓ¾çÑݵÄÄÇÑù£¬×ª»ú×ÜÊÇÔÚÕâ¸öʱºò³öÏÖ£¬ÏÈÊÇ¿´µ½ÁËsaulzy¹ØÓÚmysql4.1.11°æ±¾µÄ°²×°½éÉÜ£¬½Ó×ÅÓÖÕ ......