CODEWITHSUNDEEP
phpmysqlsqldatabase
Programmer
Programmer

Reputation: 1294

How to create sql file?

I have 6 tables already created, which I access from mySQL Workbench. Is there any way I can get the query for the creation of the database and all 6 tables inside it? I need this so that I can create that database and all 6 tables on it, on another computer simply by double clicking an sql file. Thanks in advance :)

Upvotes: 2

Views: 3479

Answers (1)

Eko Junaidi Salam
Eko Junaidi Salam

Reputation: 1681

If you want to get SQL File from MYSQL Workbench, you need to do this :

  1. Open your model.
  2. Click Database menu and choose Forward Engineer.
  3. And click next until you show like picture below,
  4. Save to file.. enter image description here

Upvotes: 2

Related Questions