How to generate MySQL data dictionary from SQL script

[@paulovictordemoraesinnocen2282]

Thank you for the video! Saved me so much time as well

[@marpinpar]

Thank you! Really useful and timesaving

[@DataResearchLabs]

Glad it was helpful!

[@justinels9591]

This is exactly what I was looking for and saved me quite a bit of time on a college project. So glad I found your video!

[@DataResearchLabs]

Glad it was helpful!

[@bryantshaver6612]

this video just saved me so much time! thank you so much for doing this.

[@marianal7428]

Literallly you have saveD my LIFE

[@DataResearchLabs]

Am happy the scripts were helpful for you. :)

[@fabsync]

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

[@popoy_g]

hi sir, what is the compatible version of mysql workbench for xampp version 7.4? thanks in advance for ur reply!

[@basselbakkar4743]

thank you so mush. can you make a video how to create a database table from mysql data dictionary? it would be kind of you. thanks again

[@DataResearchLabs]

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.

[@basselbakkar4743]

@@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

[@digitalmarketinghumans]

Does this work for other programs such as DBVisual?

[@DataResearchLabs]

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.

[@bryanedwardpaguray2978]

how about version 5.5.68-mariadb ?