MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Setting Auto Increment Value From Another Table
Lee Childress
November 21, 2017 11:56AM
Re: Setting Auto Increment Value From Another Table
Peter Brawley
November 21, 2017 12: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.