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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
