I really enjoyed your teaching method! it will be great to see a tutorial on a full text search with postgresql.. something like searching book content..
Hi Bassel. Most SQL IDE's already have that functionality built in (to generate SQL for Create Table scripts). In MySQL Workbench, try the following: 1. Open MySQL Workbench 2. Right-Click on the table you want to script (in the "navigator" tree control) 3. Select "Send to SQL Editor" then "Create Statement" The exact SQL necessary to create the table will be created. 4. Hit enter twice to give some whitespace below the "CREATE TABLE" statment that was auto-generated. 5. Repeat steps 1-4 again and again for each table you want to add and your script will grow. All primary keys, foreign keys, contraints, etc. will be part of the script. This is a better, simpler, off-the-shelf solution for what you need. I do appreciate your feedback and add some point should do a training video on how to do the above and other tricks with MySQL Workbench.
@@DataResearchLabs thank you so much for your answer, but i mean if i have an Excel file with a metadata and i want to create a table according to the metadata in the Excel file but not manually. how can i do that? with another words, i need a script to do that. I hope now it's clear what I want. best regards
Assuming you meant "DBVisualizer" which I'd classify as a universal SQL IDE (Integrated Development Environment), then yes. The reason is that the data dictionary script is just SQL commands that can be run from any IDE -- I've run from MySQL Workbench and DBeaver, so don't see a reason why DBVisualizer would not work.