MySQL Help!

[ukyellowpage]

Tweet

I am new to My SQL & PHPMyAdmin, and am trying to build my first table. I have created a table anyway in phpMyAdmin, 16 columns, 19 rows, and have imported a CSV file from AW. The process gone well but just that the table is empty! I can't figure out what has gone wrong. I basically follow instruction in http://www.a4uforum.co.uk/showthread...MySQL+datafeed

Could anyone help please? That would be very kind of you. Cheers

[ianm]

Did you check that the right options were chosen for the importing. My version of PHPMyAdmin defaults to ; as the field delimiter so I have to change it to ,.

[ukyellowpage]

yes, and the phpMyAdmin also showed that 19 rows (all rows from the csv file) have been imported. However it is just blank table when I saw from the "browse" button. Cheers

[lakrasia]

Is it because you only have 16 fields? I am importing 18 fields from the Affiliate Window feed and it works fine.

[ukyellowpage]

Good point lakrasia but I got an error message when try to create a table with 18 fields:

MySQL said:
#1070 - Too many key parts specified. Max 16 parts allowed



What's the problem? Anybody any ideas? PLEASE! Thank you and cheers Lakrasia

[ianm]

Are you specifying all the fields as being primary key? If so they shouldn't be.

[ukyellowpage]

Nope... have select "index" though.

thanks ianm

[ianm]

You don't need to select index for every field - it will slow down uploading as it will have to index every field.

Just index any fields that you do searching and sorting on (for example prod name, id and perhaps the categories).

[ukyellowpage]

Thanks for your advice ianm, but still the table is empty

[lakrasia]

You mention a csv file. Did you download a zipped file and forget to unzip it?

Did you blank out 'lines terminated by' and 'fields escaped by'?

[ukyellowpage]

Thanks lakrasia now I manage to import the csv file (imported as a .txt file anyway) into my table by blanking all field except "field terminated by" - but it gives me another problem:

some data are messed up, i.e. advertiser name appear in column refNumber and so on.... what's wrong again?

Cheers

[lakrasia]

I'm not sure how you ended up with a .txt file. Perhaps this is the problem. You really need it to be in csv format - if a comma is missing, then the data will end up in different columns.

[ukyellowpage]

Imported original unzipped csv file, still give me mess up columns.....

Cheers and thanks a lot lakrasia for your time today - and to all other guys.

[lakrasia]

I've sent you a PM to offer remote assistance.

Alternatively, there's another way of doing it - I haven't tried this yet, but it sounds like a really good idea and I will be using it when I finish what I'm working on at the moment.

http://www.a4uforum.co.uk/showthread...threadid=26166

[admad1]

Originally posted by ukyellowpage
Imported original unzipped csv file, still give me mess up columns.....

Cheers and thanks a lot lakrasia for your time today - and to all other guys.

This may help

http://www.flatmysql.com/

http://www.flatmysql.com/help/excel.htm