PHP IDE :: NuSphere Forums :: View topic

Posted: Fri Jul 23, 2010 12:17 am

I've got no experience about PhpED's regular expressions.
So I need help.

I have a csv file.
I want to make this to sql file.

I got

Quote:

^.*,.*,.*,.*,.*,.*,.*$

does well find my datas on csv file.

But how to change this to INSERT statement?
In other expressions

Quote:

INSERT INTO zipcode_2010 VALUES ('^1','^2','^3','^4','^5','^6','^7');

is right.

How to make csv file's eachdata to those INSERT statement?
I want to know.

Plz, Help me. Have a great day.

Posted: Fri Jul 23, 2010 10:01 am

Do you use phpMyAdmin by any chance? You can import a CSV file using it.

Even if you don't use phpMyAdmin, and assuming you use MySQL, you can use mysqlimport.