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://lists.mysql.com/[EMAIL
[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
/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
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
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
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