[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? What
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
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,
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
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
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
