z247 wrote:
Is this the only option? I get Access denied.
CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH
ROW SET @sum = @sum + NEW.amount;
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation
Read the error message.
You don't have "super"
On Wednesday 05 July 2006 12:26 pm, z247 wrote:
> How would a foreign key constraint work in this case?
An example of a foreign key constraint would be something like:
CREATE TABLE users (
id BIGINT UNSIGNED NOT NULL UNIQUE,
username VARCHAR NOT NULL,
password VARCHAR NOT NULL,
status INT
How would a foreign key constraint work in this case?
Thank you
--
View this message in context:
http://www.nabble.com/Dynamic-link-tf1896489.html#a5188192
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
Is this the only option? I get Access denied.
CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH
ROW SET @sum = @sum + NEW.amount;
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation
This is sample code from mysql site,
http://dev.mysql.com/doc
On Wednesday 05 July 2006 11:40 am, Jay Blanchard wrote:
> [snip]
> Say I have two regular tables (table1, table2) and what a column
> (status) in
> the second table to update when it changes in table1. For example, if I
> set
> the status for a user in table1 to "0", the status for all that user's
[snip]
Say I have two regular tables (table1, table2) and what a column
(status) in
the second table to update when it changes in table1. For example, if I
set
the status for a user in table1 to "0", the status for all that user's
records in table2 dynamically changes to "0".
Can this be done? Wh
