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 difference between group by and order by clause?

1014

Which is better mysql or mssql?

981

How do you determine the location of mysql data directory?

984

What is the use of pdo?

998

How to check server status with 'mysqladmin'?

1231

What are the features of mysql?

1042

Is mysql server free?

979

What are the functions of mysql?

985

how you will Create a database on the mysql server with unix shell.

1106

What is a scalar function?

1041

What is save point in mysql?

1003

Why do we use views instead of tables?

959

Explain the difference between primary key and candidate key in mysql?

1010

What is the datatype for password in mysql?

1029

What are the advantages of mysql?

1038