I want to save the query I wrote in mysql console to a .sql file... for example :
"CREATE TABLE Employee(id...,name...,salary);"
I want to save the code instead of it's result. thanks
Asked
Active
Viewed 1,025 times
0
Fatemeh Abdollahei
- 3,040
- 1
- 20
- 25
saeid pournezhad
- 1
- 1
-
Take a look at [this](https://stackoverflow.com/questions/11190337/what-is-the-equivalent-of-the-spool-command-in-mysql) – Gurwinder Singh Dec 26 '17 at 04:25
-
How are you executing this query? On the terminal, through a shell script... How? – Yusuf Hassan Dec 26 '17 at 04:26
-
WAMP app---->mysql console – saeid pournezhad Dec 26 '17 at 04:40
1 Answers
0
Pass the query in a variable and then execute it. This way, variable will hold the query and you'll be able to do whatever you want:
- execute it
- send it to a file
- any other operation...
query="CREATE TABLE Employee(id...,name...,salary)";
mysql -u root -h localhost -P 3306 -p -e "$query"
echo $query >> query.sql
This'll print the data as well as populate a file query.sql in your PWD. The above example is a part of a shell script.
Yusuf Hassan
- 1,933
- 1
- 12
- 21
-
I just want to have .sql file that's written in it ,say,"CREATE DATABASE Company;" – saeid pournezhad Dec 26 '17 at 04:43
-
But I want to save this file using the mysql console environment – saeid pournezhad Dec 26 '17 at 04:44
-
Happy to help :) Please accept/upvote it if it serves what you were looking for. – Yusuf Hassan Dec 26 '17 at 04:46
-
To avoid printing anything, simply skip the execution part i.e. `mysql -u root -h localhost -P 3306 -p -e ""` – Yusuf Hassan Dec 26 '17 at 04:46