469,310 Members | 2,750 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,310 developers. It's quick & easy.

perl/awk dealing with mysql. request/help

130 100+
hello all

i yet to start this project. i need some edvice.

i want to insert to my db

few fix words from a .txt file

what is the best language to write it? awk or perl ? i can write it in php but i know the first languages are better for this kind of job, but i am not sure of how to send the data to mysql with them

can anyone post a snippt please
the file.txt looks like that :

date spoken language time name
2007-10-24 english 20.00 name
2007-10-24 english 20.00 another_name
Nov 14 '07 #1
2 1313
numberwhun
3,503 Expert Mod 2GB
hello all

i yet to start this project. i need some edvice.

i want to insert to my db

few fix words from a .txt file

what is the best language to write it? awk or perl ? i can write it in php but i know the first languages are better for this kind of job, but i am not sure of how to send the data to mysql with them

can anyone post a snippt please
the file.txt looks like that :

date spoken language time name
2007-10-24 english 20.00 name
2007-10-24 english 20.00 another_name
Although you can write programs in AWK, there is no database interface in AWK that I know of. My suggestion, if you want to easily interact with a database is to use Perl. You will want to read up on the DBI module for that.

Regards,

Jeff
Nov 14 '07 #2
Amzul
130 100+
thanks jeff but i belive i found a better way

it can all be done via mysql

so i just need to write a small script in php that create the right query. thanks for your time
Nov 14 '07 #3

Post your reply

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

Similar topics

2 posts views Thread by GC | last post: by
1 post views Thread by Mavis | last post: by
reply views Thread by John Ntow | last post: by
3 posts views Thread by pc | last post: by
6 posts views Thread by surfivor | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.