MySQL Forums
Forum List  »  Newbie

Re: creating a table is there another way to do this?
Posted by: Barry Galbraith
Date: September 21, 2022 06:02PM

You can make mysql commandline client read from a file with "<" in from.
C:/>mysql -uroot -p < "C:/path/to/your/text.sql"
This needs for the location of the mysql commandline client to be in your windows PATH, otherwise you need to CD (change directory) to where mysql client is, and then run your command.

Good luck,

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.