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, 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.