List:General Discussion« Previous MessageNext Message »
From:Dan Greene Date:December 11 2003 1:54pm
Subject:RE: How to READ/WRITE directly on MyISAM data files ?
View as plain text  
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
> 
> 
Thread
How to READ/WRITE directly on MyISAM data files ?Stéphane Bischoff11 Dec
  • Re: How to READ/WRITE directly on MyISAM data files ?Martijn Tonies11 Dec
  • Re: How to READ/WRITE directly on MyISAM data files ?Stephen Brownlow12 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Stéphane Bischoff11 Dec
  • Re: How to READ/WRITE directly on MyISAM data files ?Martijn Tonies11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Jay Blanchard11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Stéphane Bischoff11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Jay Blanchard11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Dan Greene11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Stéphane Bischoff11 Dec
  • Re: How to READ/WRITE directly on MyISAM data files ?Martijn Tonies11 Dec
  • RE: How to READ/WRITE directly on MyISAM data files ?Matt Griffin11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Jay Blanchard11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Stéphane Bischoff11 Dec
RE: How to READ/WRITE directly on MyISAM data files ?Dan Greene11 Dec