Raymond,
>I am new to Mysql and am working a project where I want a user
to
>be able to see some records but not all records in a particular
table.
That's what the WHERE clause of SQL's SELECT statement is for. Read the
MySQL tutorial (http://dev.mysql.com/doc/mysql/en/tutorial.html) and
the
Hi,
This is a design question.
the selection of data types must be intergrated to your application.
If you have a table with :
name type
apple fruit
redcolor
a simple query like
select * from tbl where type ='fruit' will give only fruits to the users.
You can if you have mysql 5.x create
I am new to Mysql and am working a project where I want a user to be able to
see some records but not all records in a particular table.
I am assuming that I would need to create a subset table based on the original
table and give the user access to only the subset table.
Is it possible to do thi
