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]
a shortcut a day keeps the mouse away
Archives for the month of: January, 2007
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]
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]
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]
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 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]
I’m getting addicted to learning the Amarok keyboard shortcuts.
Windows+Shift+(num)+ – will take you back 5 seconds
Windows+Shift+(num)+ + will take you forward 5 seconds
Did I mention these are Global keyboard shortcuts, as in… Amarok does not have to be open (it does have to be running) for them to work? Too cool!
[tags]daily-shortcut, productivity, accesskeys, amarok[/tags]
To globally increase your volume level in Amarok, just hit Windows + (numpad) + … to decrease it just hit Windows + (numpad) -
[tags]daily-shortcut, productivity, accesskeys, amarok[/tags]
A while back I posted how to lock your computer in Windows and on a Mac and I completely forgot GNOME:
Press CTRL+ALT+L and your screen will be locked.
[tags]daily-shortcut, productivity, accesskeys, gnome[/tags]
This one is a little difficult to explain, but oh so useful.
CTRL+SHIFT+* in Excel will select a block of the spreadsheet until it finds surrounding whitespace. Kind of hard to understand, so here’s a demonstration…
If you’re playing at home: I’m running Excel 2003, and I went File > New > General Templates > Spreadsheet Solutions > Loan Amoritzation > OK. Tools > Protection > Unprotect. Whew. Now that’s out of the way…
Go to Cell D7.
Press CTRL+SHIFT+*.
Enjoy =)
[tags]daily-shortcut, productivity, accesskeys, excel[/tags]
