Re: Import Data from txt/csv into MySQL Table

[Mindaugas Brazenas]

Hi,

It is really easy to import data from *.txt.
OK lets see what we have... and we have a quick tutorial how to do it! :)

1. create rs.txt file and put some date into it:

1 Jhon 22
2 Mike 18
3 Peter 32
4 Tom 19

note that the fields must be separate by tab

2. create the table, that will be filled with content form rs.txt
mysql> create table data_table (id int, name varchar(20), age int);

3. and fill it!
mysql> load data local infile "rs.txt" into table data_table;

P.S. to have this work successfully make sure that rs.txt is located at
'MySQL Sverver 6.0\bin'

4. let's see what we have:
mysql> select * from data_table;
[there is a nice table]

5. feel free to ask if you failed to get wanted result :)

Good luck!

Mindaugas Brazenas