linux n mysql

[dhawalsant]

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...

 

[ahref]

change it to csv and use query

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

 

[din]

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

 

[dhawalsant]

thanks guys,,,,

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

 

[mehulved]

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

Or alternatively, you can use mysqlimport command.

man mysqlimport

 

[~Phenom~]

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.