How to import the txt data exported from Oracle to another MySQL database is as follows: sequential number name problem 001 Zhang San cold 002 Li Si fever 003 Wang Wu headache How to import the file data to the MySQL database through PHP ------ how to import the txt data exported from Oracle to another MySQL database
How to import txt data exported from Oracle to another MySQL database
The txt file data is as follows:
Sequential number name problem
001 Zhang San caught a cold
002 Li Si fever
003 Wang Wu's headache
How to import the data in this file to the MySQL database through PHP
------ Solution --------------------
SQL code
Load data local infile ......
------ Solution --------------------
Directly run SQL statements without using php:
Load Data InFile 'd:/Data.txt 'into table' tabletest' Fields Terminated By '\ t' Enclosed By' \ n ';
Or the graphic interface is imported.
------ Solution --------------------
This is the title format. you need to delete the title before considering the import method.
------ Solution --------------------
You can also use the import and export tool that comes with SQL SERVER.