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

Can a table have multiple primary keys?

835

What is the purpose of using a heap table?

1018

What is the default port for MySQL Server?

1012

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

891

what is the difference between between and in operators in mysql?

962

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1392

Can mysql scale horizontally?

925

Is mysql free for commercial use?

848

What is mysql community server?

870

How to analyze tables with 'mysqlcheck'?

1142

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1078

Can I use mariadb instead of mysql?

863

How can you retrieve a particular number of records from a table?

891

What is pragma autonomous_transaction?

818

What is key in mysql?

834