faqts : Computers : Databases : MySQL : Design

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

Entry

Database: Design:MicroOLAP Database Designer for MySQL: How to generate SQL code to create database?

May 8th, 2005 07:24
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 08 May 2005 - 09:02 pm ------------------------

Database: Design:MicroOLAP Database Designer for MySQL: How to 
generate SQL code to create database?

---

Steps: Overview:

 1. -Create or load an existing database

 2. -Do possibly some changes

 3. -To generate the equivalent
     SQL source code (e.g. to create
     a similar database also
     on your website)

     1. -Select from menu option 'Database'

     2. -Select from list 'Generate database'

     3. -Click button 'OK'

     4. -Select all, copy and paste the generated SQL code

     5. -Rerunning this SQL code will recreate that databases

---
---

Internet: see also:

---

Database: Design: MicroOLAP Database Designer for MySQL: Link: Can you 
give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/36020/fid/1803

---

Database: MySql: Operation: Replace: How to replace a MySql database 
with other MySql database?
http://www.faqts.com/knowledge_base/view.phtml/aid/36071/fid/52

----------------------------------------------------------------------