Insert txt file data in to my sql

Please some one help me to insert following rows in to mysql

I have attache txt file.
Please insert it in to mysql and give me the sql.

If you can please tell me how to do it

Thanks

 

Sure thing. You need to substitute the field for the right one.

LOAD DATA INFILE 'data.txt'
        INTO TABLE jokes
        FIELDS TERMINATED BY '\n'
  (joke);

Code (markup):

Where it says insert into "jokes" change that to the name of the DB. at the bottom where it says "joke" change that to the correct table name.

Make sure the data.txt is in the current directory, or specify the entire path.

 

Here, since you seem quite lazy

 

thanks a lot Lexiseek !
I added rep to you again thanks.........

 

No problem, man. Enjoy it