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 unix timestamps and mysql timestamps?

1016

How to load data files into tables with 'mysqlimport'?

1000

What are the mysql database files stored in system ?

1064

Is mysql a dbms?

895

How to convert character strings to numeric values?

1130

How do I create a new database in mysql?

908

What is pragma exception?

974

Is mysql a distributed database?

977

How to create a trigger in mysql?

938

What ascii 31?

959

How to use in conditions?

1013

how to Return total number of rows.

1013

What are the difference between now and current_date in mysql?

1429

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

922

How to make a column bigger and delete unique from table.

965