Reply to Re: Cant alter data in primary key fields

Your name:

Reply:


Posted by J.O. Aho on 01/09/06 18:58

jj wrote:
> Thanks for the reply.
>
> My problem isnt that there are duplicates. My table is as simple as it
> possibly gets:
>
>
> table name : UPS
>
> --------------
> discount(PK)
> --------------
> 0.33
> --------------
>
> It only has one value in the entire table.
>
> Now if I try to alter the 0.33 to any value it just reverts back to the
> 0.33. No error is given at all either.

Okey, what SQL server do you use (name and version)?
What about does the user you logged into the SQL server has the right to
modify it? There is the GRANT that will be needed to be issued by the SQL
admin user to allow other users to get the priviliges to do different things
with databases and tables.

You can try the ALTER to modify the table so that the column no longer will be
the primary key.


For Mysql:
http://dev.mysql.com/doc/refman/5.0/en/grant.html
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


//Aho

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация