By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,142 Members | 1,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,142 IT Pros & Developers. It's quick & easy.

inserting column values from text file to table in database

P: 69
Hi guys,

I am new to this stuff and i have NO IDEA what to do. I have a text file where each line is a value for the name of a department.There are 500 departments.how do I insert that into a mysql database in a table.Please explain fully.the id for the table is an auto number so that is not a problem

Thanks alot
Nov 6 '07 #1
Share this Question
Share on Google+
1 Reply


amitpatel66
Expert 100+
P: 2,367
Hi guys,

I am new to this stuff and i have NO IDEA what to do. I have a text file where each line is a value for the name of a department.There are 500 departments.how do I insert that into a mysql database in a table.Please explain fully.the id for the table is an auto number so that is not a problem

Thanks alot

Check for mysql import here
Nov 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.