We have applications for colleges in India. The same idea of having single
table for manipulating students records. but we are not following archiving
concept.
Ex stupersonal. and stuclass these tables are playing wide role in our
application. After 7 years now there are 9000
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Wednesday, February 17, 2010 11:41 PM
To: Jerry Schwartz
Cc: MY SQL Mailing list
Subject: Re: how things get messed up
Dear Jerry Schwartz
We have applications for colleges in India. The same idea of having single
table for manipulating
*cough*partitioning*cough*
On Thu, Feb 18, 2010 at 5:24 PM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Wednesday, February 17, 2010 11:41 PM
To: Jerry Schwartz
Cc: MY SQL Mailing list
Subject: Re: how things get messed up
Dear
Reproduced in 5.1.43. Could not reproduce it in 5.0.66
-Original Message-
From: Yang Zhang [mailto:yanghates...@gmail.com]
Sent: Wednesday, February 17, 2010 6:05 PM
To: mysql@lists.mysql.com
Subject: auto_increment weirdness
Hi, for some reason, I have an auto_increment field that's
i have two table, T1, T2. and 1 trigger.
trigger is before update on T1 and it updates some values in T2. once
it's done, the trigger tries to delete the subject row of T1 (delete
from T1 where id = new.id)
i tried with second trigger on T2 (after/before update) and with a
procedure inside this
Dear MySQL users,
MySQL Community Server 5.1.44, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.44 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
--- Original Message ---
From: viraj kali...@gmail.com
To: mysql@lists.mysql.com
Sent: 19/2/10, 05:48:41
Subject: ERROR 1442 (HY000) when delete inside trigger statement
issue: ERROR 1442 (HY000): Can't update table 'T1' in stored
function/trigger because it is already used by