Re: Unknown column 'subtest_id' in 'NEW'
Posted by:
Rick James
Date: September 06, 2013 08:31AM
> UPDATE seq SET id = id + 1;
> SET new.subtest_id = (SELECT id FROM seq); <-- Failure is happening here
Almost all occurrences of "Sequences" can be replaced by usage of AUTO_INCREMENT.
While this does not explain your problem, it may be a workaround.
Subject
Written By
Posted
September 04, 2013 06:22AM
September 04, 2013 10:12AM
Re: Unknown column 'subtest_id' in 'NEW'
September 06, 2013 08:31AM
September 10, 2013 07:27AM
September 12, 2013 09:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.