MySQL Forums
Forum List  »  Newbie

Re: How to generate new table out two other table?
Posted by: Peter Brawley
Date: March 09, 2022 01:13PM

Quote

I always get the following error:

mysqldump: Couldn't find table: "id_plant < 10"

mysqldump -uUSR -pPWD DBNAME TBLNAME --where="id_plant < 10"

... where USR=your mysql user name, PWD=your MySQL pswd, DBNAME=database name, TBLNAME=table name

> limit the selction in workbench

Much simpler and more reliable to do it directly. If you must do it in WB, you'll need to read the relevant section of the WB manual and/or ask in the WB forum.

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.