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
/doc/refman/5.1/en/using-triggers.html
Thank you
--
View this message in context:
http://www.nabble.com/Dynamic-link-tf1896489.html#a5188173
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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
Can this be done? What method is used?
Thank you
--
View this message in context:
http://www.nabble.com/Dynamic-link-tf1896489.html#a5187212
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on
my system after installation.
Both configure and mysql_install_db fail due to missing dynamic link libraries
/usr/lib/libdl.so.1 and libnsl.so.1. The system does have libdl.so and
libnsl.so.
The source distribution
