Without a unique identifier, the only way you're gonna get to update right is to use other
data in the row to identifiy the record...
so with a table structure of
name
address
state
your users can select anything they want, filtering w/ a where clause.
If you grant them update on the table, then they'll just have to:
update your_table
set name = 'Dan'
where name = 'Daniel'
and address = '55 main'
and state = 'Virginia';
I don't agree with this approach, mind you, it breaks all kinds of best practices....
maybe it would help if you explained _why_ you don't want your users to see a numerical id
field for each record....
> -----Original Message-----
> From: Stéphane Bischoff [mailto:Stephane.Bischoff@stripped]
> Sent: Thursday, December 11, 2003 8:43 AM
> To: 'Jay Blanchard'; MySQL (E-mail)
> Subject: RE: How to READ/WRITE directly on MyISAM data files ?
>
>
>
> Thank you, but I already know the basics of SQL SELECT statements.
>
> What I am trying to say is, if a User writes a SELECT clause,
> I do not want
> him to
> see the RowID field. I do not want him to write a long SELECT
> statement,
> especially if my
> table has 20 FIELDS or more. (Can you imagine the user
> writing these queries
> all the time).
>
> I want him to be able to write SELECT * FROM ATABLE.
>
> Thank you,
>
> Stéphane.
>
> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard@stripped]
> Sent: 11 décembre, 2003 08:41
> To: Stéphane Bischoff; Martijn Tonies; MySQL (E-mail)
> Subject: RE: How to READ/WRITE directly on MyISAM data files ?
>
>
> [snip]
> So my first question should be : Is there a way to hide a field ??
> [/snip]
>
> SELECT only the information you want. Let's say I have
>
> RowID
> Name
> Address
> City
>
> And I only want Name Address and City
>
> SELECT Name, Address, City FROM table WHERE RowID = 'foo'
> UPDATE table SET Name = 'foo' WHERE RowID = '12'
>
> etcetera
>
> A good book on SQL basics will get you a long way on things like this.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
