CHECK constraint

2005-06-25 Thread Chris Andrew
Dear List, My system is RedHat EL3 and MySQL 5.0.7-beta. I wanted to implement a check constraint (below), but after some testing and googling, it seems I can't do this with MySQL. I've read suggestions that check(s) should be done using triggers. Is a trigger a preferred method of achieving the

RE: CREATE and DROP Privileges

2002-05-01 Thread Chris Andrew
Or else, you can create a different database exclusively to > be used by > the user and give the permissions only to the corresponding user. > > Gurhan > > -Original Message- > From: Chris Andrew [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 10:19 AM &

CREATE and DROP Privileges

2002-05-01 Thread Chris Andrew
I have a user account that needs to create and subsequently drop tables (not temporary tables). Is it possible to give permissions to this user to drop just the tables that he creates - without allowing him to drop any other table ? Thanks, Chris (MySQL - to satisfy your mail filter)

Determine Percentages

2001-09-03 Thread Chris Andrew
UM(Packets)/1234567*100 AS Percentage FROM tblIp GROUP BY SrcIp; Chris Andrew Oxspring Network Solutions Limited Tel: +44 (0)1226 761188 Fax: +44 (0)1226 761199 Email: [EMAIL PROTECTED] Web: www.oxspring.com - Before posting, pl