CODEWITHSUNDEEP
mysqldatabase
user1779158
user1779158

Reputation: 13

import data from .txt file into mySQL table

I have created the table in mysql and the table is created Now I want to insert the data into the table but the issue is that the data which I want to inset into that particular table is saved with me in a separate text file , the same data I want to insert into the table , Please advise how I can insert the data of the text file into that particular table .I have also downloaded the sql gui browser tool also, Please advise.

Upvotes: 0

Views: 1078

Answers (1)

thar45
thar45

Reputation: 3560

From my understanding

Either you should use any programming language to read your text file and insert it

or

if you would like to do avoid the programming lang then you can import the text file using sql comments in the file with those data to your db as mysql import process.

Document

More Info

Upvotes: 1

Related Questions