Even though I'm not one of the creators, thinking through it logically, I
would say it wouldn't work. A select * statement would retrieve the data,
so yes, you could add columns to the permission tables but you need to be
able to use the retrieved data in someway, usually programmatically.
... Actually, I'm wrong, you could do it. You would need to download the
source code and then modify the relevant code to incorporate your extra
column.
----- Original Message -----
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 0:55
Subject: Re: Adding columns/tables to the mysql permissions database
> So, when MySQL goes to its own permisions table, it does a "select *", not
a
> "select user, host" etc.? Why is that? It seems that for flexibility it
> would name the fields it was selecting so it would know the order would
> always be the same.
>
> Anyway, if I don't change the order of columns (i.e., adda column on the
end)
> I should be OK?
>
> Thanks.
>
> j----- k-----
>
> On Wednesday 16 May 2001 03:02, Sinisa Milivojevic wrote:
> > Hi!
> >
> > If it would change the order of columns, it would create huge
> > problems.
> >
> >
> > Regards,
> >
> > Sinisa
> >
> > Joshua J. Kugler writes:
> > > -> This was posted before, but under a title that made it sound like a
> > > "read the manual, silly" type of question. Hopefully someone can
answer
> > > this.
> > >
> > > I would like to be able to filter users based on other criteria than
just
> > > their name/host. Will mysql complain/refuse to work if I add columns
to
> > > the "mysql" database "user" table, or any other table in the "mysql"
> > > permissions database? If I could do that, it would greatly simplify
> > > things for me.
> --
> Joshua Kugler
> Associated Students of the University of Alaska Fairbanks
> Information Services Director
> [EMAIL PROTECTED]
> 907-474-7601
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
