Hi, > I am not shure if I need to. > > Here's why I am asking: > > I have a table that does not have a primary key and I need to update only > one row. > This complicates my Update Query since I cannot specify a Where clause.
Well, as you have figured out, without some kind of unique ID, it's pretty much impossible to update a row. > I did had a primary key RowID (AUTO INCREMENT) to be sble to specify a row > in my query. > But this Field (RowID) can now be seen when I do a SELECT query. I did not > find a > way to hide this field. > > So my first question should be : Is there a way to hide a field ?? Well, that depends on how you are displaying the data, doesn't it :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]