importing csv file

Problems with the Windows version of XAMPP, questions, comments, and anything related.

importing csv file

Postby gsdoby » 14. September 2011 16:08

Forgive me if this is the wrong forum. I am trying to import a csv file that I saved from a Microsoft excel file. The import works except it will not import records that are not unique for a certain field. when I go the structure I see a column indicating that the field is unique but do not see how to change it. Any help is appreciated
gsdoby
 
Posts: 19
Joined: 08. August 2011 18:13

Re: importing csv file

Postby JonB » 14. September 2011 17:50

I'm guessing you mean 'into MySQL'

\ I see a column indicating that the field is unique but do not see how to change it\


I'm guessing again - You mean in phpMyAdmin???

I will say before you change anything, its likely that any fields/colums that are marked as 'unique' are part of an index - and - if you change that you may break the script/application. :shock:

The last is just based on experience. If its your own code - do what you will.

http://www.phpfreaks.com/forums/index.p ... c=259326.0

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: importing csv file

Postby gsdoby » 14. September 2011 18:30

You are correct with both of your guesses. I am trying to get my database built before I actually start writing my code. This is my first project so I am learning step by step. I went to link provided in your post but it did not help my situation. Thanks for your response
gsdoby
 
Posts: 19
Joined: 08. August 2011 18:13

Re: importing csv file

Postby gsdoby » 14. September 2011 18:52

Finally figured it out. Thanks for the help
gsdoby
 
Posts: 19
Joined: 08. August 2011 18:13

Re: importing csv file

Postby JonB » 14. September 2011 19:00

Glad you got it sorted -

If you are building your own projects, you should learn about MySQL Workbench - way, way more powerful than phpMyAdmin. (and free). Don't get me wrong, I use both at times - but for database design - MySQL Workbench wins handsdown.

http://wb.mysql.com/

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests