MySQL Workbench - How to create a Model from existing scripts

When using MySQL Workbench you can create a Model from existing scripts. That is called "Reverse Engineering using a Create Script". Useful tool if you need to visualize and finishing modeling your data base.

Here are the steps:

Open MySQL Workbench, click on File --> Import --> Reverse Engineering MySQL Create Script

On Input and Options screen click on Browse and select your existing script. Then Click on execute...

When on Reverse Engineering Progress screen do no change anything there, just click on Next...
Then on the next screen , just click on Finish...

After clicking on Finish you'll see the EER Diagram screen. Here you just can drag and drop all the tables (on the left side) to the Diagram part (right part)

As soon as you start dragging and dropping tables to the Diagram side, you'll see the tables with their relationships. After that, you can export that diagram in any format you need.

As we can see in general, MySQL Workbench is a very intuitive software with tons of useful tools like this "Reverse Engineering MySQL". Feel free to play around with it and if you have any questions just post a comment or email me....

Google Chrome - ShortCuts for Pros

As we already know, Google knows everything and it is everywhere. Email, blogs, cloud storage, OS + many other things...and of course Google's browser: Chrome.

I have to admit that at first I didn't like Google Chrome. I was using Firefox for so many years that I didn't feel like using another browser (I was lazy, I know). However, one day, my lovely Firefox crashed and suddenly started slowing down my computer, so my only option was migrating to Google Chrome; and actually it was a good idea. Google Chrome, at least for me, seems to be more stable and even faster that other browsers, plus it lets you link some features from others Google products.

And if you are a Chrome-lover, you will enjoy this post. I'm posting the most useful shortcuts for this web-browser. Believe me, you life will change after you learned and start using these commands (just kidding, it won't change a lot, but it help you with your tasks)  =)



SHORTCUT                                                                       KEYS

1.New Window:                                                                  Ctrl+N

2.New Incognito Window:                                                Ctrl+Shift+N

3.New Tab:                                                                         Ctrl+T

4.Close Tab:                                                                        Ctrl+W

5.Close Window:                                                                 Ctrl+Shift+W

6.Add to Bookmarks:                                                         Ctrl+D

7.Show/Hide Bookmarks Bar:                                          Ctrl+Shift+B

8.Downloads:                                                                       Ctrl+J

9.History:                                                                             Ctrl+H

10.Open link in new tab:                                                    Ctrl+Click

11.Open last closed tab:                                                      Ctrl+Shift+T

12.Returns the tab to its original position:                       Press Esc while dragging a tab

13.Switches to the tab at the specified                              Ctrl+1 through Ctrl+8
position number on the tab strip:

14.Switches to the last tab:                                                Ctrl+9

15.Switches to the next tab:                                              Ctrl+Tab or Ctrl+Pg Down 

16.Switches to the previous tab:                                       Ctrl+Shift+Tab or Ctrl+Pg Up

17. Closes the current window:                                         Alt+F4

18.Closes the current tab or pop-up:                               Ctrl+W or Ctrl+F4