From: Martijn Tonies
Date: December 11 2003 1:44pm
Subject: Re: How to READ/WRITE directly on MyISAM data files ?
List-Archive: http://lists.mysql.com/mysql/155489
Message-Id: <032301c3bfec$decf23d0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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