MySQL Forums
Forum List  »  Newbie

Re: How to generate new table out two other table?
Posted by: Peter Brawley
Date: March 09, 2022 11:08AM

As you can see, those Create Table scripts aren't usable. Best generate them with mysqldump.

And we'll need sample data for act_gen_raw and dt tables. As the docs make clear, mysqldump accepts a Where clause, eg ...

--where="id<10"

Options: ReplyQuote




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.