inserting records in phpmyadmin?

tres · 11 Dec 2008 at 19:01

hello all,

i have a big list of items that i want to insert into my mysql database on my site

i can format the xls so that each row has the appropriate fields

but how do i insert it into the database? which format to save in?

any help would be great, thank you

t31os · 11 Dec 2008 at 19:14

Choose the database, then the table, then the link for 'Insert' at the top?

Or click on SQL and run an SQL statement....

"INSERT into YOURTABLE (your,table,rows,etc,etc) VALUES (your,values,go,here,etc)"

Where the table rows are your actual table rows and the values are your values you wish to enter.

I'm not great at MySQL but it sounds like you simply need an insert statemnt unless you're talking about only a few records, then you could do it by hand, 1 by 1...

tres · 11 Dec 2008 at 21:21

1,300 records!

oh, so i can just export my xls into csv you think?

fishfishfish · 11 Dec 2008 at 22:19

Yes, if you re-save the Excel spreadsheet as .csv you can then use the import feature to pull the data in.

tres · 12 Dec 2008 at 16:36

Ok, managed to get everything set up, but when i import:

Error
Invalid parameter for CSV import: Fields escaped by

What options to I need??

I'm doing fields terminated by ,

i've left the others empty, because i can't use the default for other options (such as " and \) because they're present in some of my data i'm imported and i thought it might wreck everything