MySQL database transfer, access,sql server to MySQL graphics tutorial _php tutorial

ODBC is an application interface that enables various databases to have the same interface

First go to PHP enthusiasts station http://www.phpfans.net/download.php?cid=1&page=3 download MySQL ODBC driver. Currently the latest version is V5
Because version 5 is prone to garbled problems, it is strongly required to use version 3.51

/*
Author: I'm not a fish.
Website: http://www.phpfans.net
Blog: HTTP://WWW.PHPFANS.NET/SPACE/INDEX.PHP/2
Email:deng5765@163.com
qq:245821218
*/

Install MySQL ODBC driver ...

1. First use phpMyAdmin to build a test database, there is no data table in which

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215002155.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/0623215159-0.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

2. Open [Control Panel] [Administrative Tools] Double click [Database (ODBC)]
Select the [System Data Source] tab and click [Add]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215003874.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/06232140b-1.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

More articles PHP enthusiasts station http://www.phpfans.net

3. Open an Access database
(1) Select a table, export ...

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215003280.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/062321O59-2.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

(2) SELECT [ODBC Database]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215003353.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/0623216209-3.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

4. Choose the [Machine Data Source] tab, select the dwmxphp that we previously set and then [OK]

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215003157.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/062321C21-4.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

5. After the execution is done, open phpmyadmin to see. Yes, that's the data we just imported.

screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor= ' hand '; this.alt= ' Click here to Open new Window\nctrl+mouse wheel to Zoom in/out ';} ' Onclick= "if (!this.resized) {return true;} else {window.open ('/upload/20070902215004456.jpg ');}" src= "http:/ Www.bkjia.com/uploads/allimg/131016/0623216291-5.jpg "onload=" if (this.width>screen.width*0.7) {this.resized= True this.width=screen.width*0.7; this.alt= ' Click here to open new window\nctrl+mouse wheel to Zoom in/out ';} ' Border=0>

http://www.bkjia.com/PHPjc/318440.html www.bkjia.com true http://www.bkjia.com/PHPjc/318440.html techarticle ODBC is an application interface that allows various databases to have the same interface first to the http://www.phpfans.net/download.php?cid=1 this.width=screen.width*0.7 of the PHP enthusiast station; This.style.cur ...

