To load the text file pet.txt into the pet table, use this statement: my

How to load data from a text file into a table?

Question Posted / tushar

Answer Posted / tushar

To load the text file pet.txt into the pet table, use this statement:

mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are aggregate functions in mysql?

1429

What is meant by decimal (5,2)?

1081

How internally data stores in MyISAM and INNODB table types?

2792

Is mysql same as mariadb?

940

How do I clear the screen in mysql?

1038

How do I setup mysql?

937

What language is mysql written in?

1025

What is the insert?

941

What is a crosstab query?

1007

What is the difference between truncate and delete?

1257

What is the difference between is null & is not null?

1038

How to insert dynamic values in mysql using php?

1178

How do I change directories in mysql?

945

Is mysql a database?

989

How are mysql timestamps seen to a user?

1080