SQLyog – Add User CTRL+U

Adding users and keeping up with permissions can be a pain in MySQL. Now, with SQLyog’s clean GUI, it’s easy.

Press CTRL+U and add a user.

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]

SQLyog – Export Table as SQL Statements

CTRL+ALT+E will take your current table and turn it into a nice .sql file to load onto another system or just have around as a backup.

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]

SQLyog – F6 Alters table

If you have a table selected, but you need to alter its fields/data types just press F6. You’ll be taken to the “Alter Table Properties” screen.

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]

SQLyog – Shift+F5 executes All Queries

If you have a lot of inserts/updates that you need performed, this shortcut is very useful:

Shift+F5 performs all queries.

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]

SQLyog – Alt+3 Takes you to the Table’s Data

In SQLyog, just press Alt+3 and you’ll see the data for the table you’re dealing with. SQLyog is very useful toggling between data/result/messages with Alt+1, Alt+2, and Alt+3.

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]

SQLyog – F5 Executes a Query

SQLyog is a wonderful MySQL GUI. The community edition is FREE! It works much faster than phpMyAdmin and best of all, it has a ton of great keyboard shortcuts!

F5 executes a SQL Query.

Here’s a thumbnail (linked to a bigger screenshot) of the query/result pane in SQLyog:

I just typed my query and pressed F5. Woo!

[tags]daily-shortcut, productivity, accesskeys, mysql, sqlyog[/tags]