linux n mysql

6 posts · originally from https://geek.digit.in/community/threads/linux-n-mysql.93249/

friends..

i m a novice user of linux, as i have just started learning it during my summer internship.

i m developing a project in linux which includes connectivity to mysql.

i am having data in .txt files and want to insert it into MySql database table.

please help me out how can i do this?

sorry , if you think it is a very silly ques.. but jst remember that i m a newbie to linux.
pls help...

change it to csv and use query

load data local "filename.txt" ....

You can also use phpmyadmin which is a web interface for managing mysql. Pretty easy.

thanks guys,,,,

n yes can u tell me the use of "local" in this command

ahref said:
load data local "filename.txt" ....

Or alternatively, you can use mysqlimport command.

Code:

man mysqlimport

LOAD DATA INFILE "filename.txt" INTO TABLE tablename FIELDS TERMINATED BY ',';

Modify it to suit your needs. And, in ubuntu the filename.txt should be placed in /var/lib/mysql/your_db_name or where mysql is installed.