MySQL Forums
Forum List  »  Newbie

Re: Setting Auto Increment Value From Another Table
Posted by: Peter Brawley
Date: November 21, 2017 12:37PM

Alter Table doesn't accept subqueries. I'm not at all sure your design is sound, but to do it, you will need to save the query result to a user var, then PREPARE the Alter Table cmd using that var.

Options: ReplyQuote


Subject
Written By
Posted
Re: Setting Auto Increment Value From Another Table
November 21, 2017 12:37PM


Sorry, only registered users may post in this forum.

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.