MySQL Forums
Forum List  »  Perl

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.

Options: ReplyQuote

Written By
Re: Unknown column 'subtest_id' in 'NEW'
September 06, 2013 08:31AM

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.