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 is the difference between sql and mysql and oracle?

881

Restore database (or database table) from backup.

1018

How many sql dml commands are supported by 'mysql'?

964

What is the insert?

871

What is int mysql?

943

What are the common mysql functions?

936

Explain Access Control Lists.

983

What is difference between mysql and mysqli?

915

What is data node in mysql cluster?

979

How to add a new column to an existing table in mysql?

989

Is mysql a database?

938

What is the maximum number of columns per table?

908

Is mysql a server or database?

897

How to shutdown mysql server?

1062

What is text?

956