How to import Access and Excel into Mysql Part 2_PHP Tutorial-PHP Tutorial-php.cn

How to import Access and Excel into Mysql Part 2_PHP Tutorial

WBOY

Release： 2016-07-13 17:01:37

Original

741 people have browsed it

one. Mysql database installation, database building and ODBC installation settings
Mysql and ODBC drivers can be downloaded from its homepage (http://www.mysql.com/). Click on Latest Versions on the right and download the corresponding version. . Here we need to download the Intel version of Mysql (the latest version is 3.23.40), and the ODBC driver is MyODBC 2.50.37 for NT/2000 (full setup). If you use Win95/98, the driver is different, so please pay attention to the distinction.
Then you can install it. The installation of Mysql is very simple. Unzip it to a directory (C: mysql). In Win2000, Mysql can be run as a service of Windows. Run "C: mysql inmysqld-nt --install", and then in the service of the Win2000 management tool, we can find that the Mysql service is running, but I found that it is also possible to run winmysqladmin.exe directly. At this time, you will be asked to enter a password. This is Please remember the Mysql connection password. The default connection has no password (the user is root).
The next step is to create the database and table. Since the data from Access and Excel must be imported, the table must include all fields of both. For the sake of simplicity, only some of the fields are selected for explanation. Run cmd to enter the command line mode, switch to the c:mysql in directory, and execute "mysqladmin create build". This command is to create a database. Build is the name of the database. After success, execute "mysql" and enter "Mysql>" In command line mode, execute the following command:
mysql>use build;
mysql>CREATE TABLE loupan (
id int(10) unsigned NOT NULL auto_increment,
loupantype varchar(6),
inputdate date,
at_whatsection varchar(6),
buildname varchar(50),
buildaddress varchar(50),
room tinyint(4),
hall tinyint(4),
areasize decimal(10,2),
exp_sellprice decimal(13,2),
ownername varchar(20),
contactway varchar(50),
memo varchar(255),
updatestatus char(1),
goodloupan char(1),
PRIMARY KEY (id)
);
Then the success prompt of Query OK, 0 rows affected (0.04 sec) will appear , use build above means to switch the current database to build, and the following statement is the command to build the table. The fields from top to bottom represent the ID number (automatically added by 1, and it is the primary key of the table), the type of real estate, and the input Date, area, property name, address, number of rooms, number of halls, area, expected selling price, owner’s name, contact information, remarks, update status, and property logo.
The next step is to install the ODBC driver for Mysql. The installation of MyODBC is also fool-proof. Run setup and confirm step by step. After that, you can set it in the ODBC data source in the control panel. Click "System DSN", select "Add", select "mysql" in the driver list, and a configuration page will pop up. In Windows DSN Name Enter the name of the data source, enter build here (you can also enter other names, which are not necessarily the same as the name of the database). In "MySQL host (name or IP)", enter "localhost", which means that Mysql is running on this machine. , enter the name of the database "build" in Mysql Database Name, enter "root" in User, and enter the password you just set in PassWord. If it was not set just now, leave it blank. After pressing "OK", the system data will be displayed. There is an additional "build" item in the source, so the Mysql ODBC data source is set up successfully.