sorted by: recent | see :
popular
Content Tagged with level + PHP
MySQL: How do you use symlinks with MySQL tables?
Creating table symlinks in MySQL is very easy and it is probably one of the features a lot of MySQL users overlook or never think about. You may ask, why would I want to use symlinks? Some of the reasons you would want symlinks is if you are running low on disk space on [...]
MySQL: Solution for ERROR 1442 (HY000): Can?t update table ?t1? in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
Here is a sample table you can create to test following problem/solution on:
CREATE TABLE `t1` (
`a` char(1) default NULL,
`b` smallint(6) default NULL
);
insert into t1 values ('y','1');
I have a table t1 which has column a and b, I want column a to be updated to ‘n’ when column b = 0. Here is the first version [...]
MySQL: ERROR 1442 (HY000): Can?t update table ?t1? in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
Here is a sample table you can create to test following problem/solution on:
CREATE TABLE `t1` (
`a` char(1) default NULL,
`b` smallint(6) default NULL
);
insert into t1 values ('y','1');
I have a table t1 which has column a and b, I want column a to be updated to ‘n’ when column b = 0. Here is the first version [...]