Hi All,
I'm writing a application that needs row level security in it so that
only certain users can view/change etc. certain records. I know that
MySQL currently does not have row level security, and when I've asked
this list before I've been given some helpfull suggestions (although
none
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
That might get the correct answer for you, but it does however have an extra
field in the result (which may or may not be a problem).
cheers,
noel
filter word:mysql
See that line that says accept any user (%) from any host (%) with password
null. There's your answer. It's a default entry that should be removed (I
think there's stuff in the securing mysql section of the manual about
this).
cheers
noel
On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf
rereads the grant tables.
If you can give us the exact line(s) you're putting in then that could help
us see the problem (change/mask the password of course).
cheers,
noel
On Tuesday, May 07, 2002 1:44 PM, Noel Clarkson
[SMTP:[EMAIL PROTECTED]] wrote:
See that line that says accept any user
Hi Son,
On Monday, April 08, 2002 2:37 PM, Son Nguyen [SMTP:[EMAIL PROTECTED]]
wrote:
--- BD [EMAIL PROTECTED] wrote:
Son,
At 09:48 PM 4/7/2002, you wrote:
mysql desc threads;
+-+--+--+-+-++
| Field | Type |
Hi there,
the other comments may have got you where you want but as no one had
mentioned your final option thought I'd mention (from /h at the mysql
command line)
source (\.)Execute a SQL script file. Takes a file name as an
argument.
so you can run the script from the mysql prompt.
Thanks Arjen,
seems like a bit of a fiddle but not a bad solution considering some of the
other options. Unfortunately I also need the row level locking of innodb
so it's not going to work in my case. This lead me to ponder, if this
sort of row level protection was added would it be at the
Hi all,
I'm wondering about row level privilages - being able to restrict what
people see and can update etc on a row level as well as a column/table
level.
I know that I can implement it in my program (which is what I'm currently
doing) but unless it's in the backend db then every program
You don't want to use LIKE in mysql - or have you not read about LIKE in
the fine mysql manual??
If you use LIKE you will also need to use a % sign signify which bit is the
variable bit. This is because mysql allows you to say if the variable bit
is at the start or the end or both. LIKE
Hi there,
My understanding is that there is no BOOL type in MySQL but BOOL is allowed
in create table statements (or alter table etc) for compatibility with
other databases (but MySQL uses a tinyint for a bool because it doesn't
have bool).
You can use a tinyint and say that 0 is false 1 is
Ok so
SELECT * FROM Events, Djs, EventDjs WHERE Events.eventID = EventDjs.eventID
AND Djs.DJID = EventDjs.DJID;
should give you a list with the event and the dj etc, if you only want one
event then add something like AND Events.Events.eventID = 'x' or whatever.
cheers,
noel
On Tuesday,
I
don't get 'show tables' which is what I would expect.
If there is anything else that I can provide to help sort this out I'd be
only too happy to.
cheers,
noel
On Friday, July 13, 2001 9:59 PM, Sinisa Milivojevic
[SMTP:[EMAIL PROTECTED]] wrote:
Noel Clarkson writes:
Hi all,
When
cut
interestingly, if I type shtab I get 'show ' but if I type show
tatab I
don't get 'show tables' which is what I would expect.
Does show tables actually produce a list of tables, or no tables?
On some systems, there is a bug in glibc that prevents it from working
properly, in which
Hi all,
When using the 3.23.39 client to connect to the server, pressing tab to
complete table names and field names etc doesn't seem to work. I seem to
get the mysql commands, but I thought in past clients I was able to get
table name and field name completion as well.
Have others noticed
Didn't see a response to this so here's some ideas.
You can do an INSERT INTO tablename SELECT ... statement or if you are
creating a new table to put these values into CREATE TABLE tablename
(SELECT ...). Check the manual for the exact syntax and for which version
of mysql you'll need for
How are you updating in delphi and what is the error?
if you are running a query, setting the edit state and request live (either
at design or run time) and then updating the data and it complains that
someone else has changed the record then check the TQuery settings, there
is one that
Wouldn't that depend on if the MySQL db is on the same server as the web
servers and the scripts that connect to them. It could also depend on if
the scripts use the -h option when making a connection and if this is the
ip address (as in number) or is a resolvable name. If it is all local,
I read the comments on NuSphere in the portals section:
As long as GEMINI is not released under open source, as required by the
GPL license of the MySQL server, we at MySQL AB can't recommend anyone to
use this distribution.
and I'm left thinking they are in violation of the GPL. If this is
Hi there,
I'm using MaxSQL 3.23.39 and have set up an innodb table but when I run an
update statement the timestamp field does not update automatically. Is
anyone else experiencing this, or is it an expected behaviour of innodb
tables? I couldn't find anything in the manual saying that this
I don't know about MySQL 3.22.32 but in 3.23.27 if you create a table with
a primary key of two fields, one of which is an auto increment field then
you will get the behaviour you are looking for (ie the auto inc will start
at 1 for each different value in the other field). I don't have
I've done it on a 486 with 64Mb memory and it took about an hour or an hour
and a half or so (it was a long time and I went off and did other things
while it was happening so my timing is not precise (oh that's make time for
the main part, make install much quicker) - and it was a few
21 matches
Mail list logo