This is a fairly common case I think. You have a table that has a datetime field that gets updated when a row is updated – you need to determine if a row has been updated recently.
Continue reading “Determine if a row has recently been updated using MySQL”
Tag: MySQL
Quick way to find duplicate entries in MySQL table
I recently needed a script that could find duplicate entries in a particular table so I wrote the following bash script…
Continue reading “Quick way to find duplicate entries in MySQL table”
MySQL Cheat Sheet and Field Type Sizes
Handy MySQL cheat sheet from Neal Parikh
Breakdown of MySQL Field Types with their corresponding sizes.
How to SSH into remote database from Windows
If you find yourself with a bust Mac and you have to fall back on your old ‘reliable’ windows laptop. You need to connect to your development web server using SSH, where do you start… I’ll tell you where, Google, or you may find this guide of some use.
So firstly, I need to set up PuTTY, a free and open source terminal emulator that will allow me to SSH into my remote web server.
Download PuTTY here.
Once downloaded, I need to generate a public/private key to authenticate the SSH connection from my machine to the web server.
Use another tool – PuTTYGen to generate the keys for you.
Download PuTTYGen here.
Here’s a pretty straightforward guide that I cannot be arsed to repeat on how to create the key. One difference for me was we use DSA encryption.
HANDY TIP: If you wish to use this key on a Mac (like I did once it was repaired) so that you can connect from either machine (windows or mac), then do the following.
Once you have your key created you need to export the key as an OpenSSL key and save it for later.
On with the guide…
Continue reading “How to SSH into remote database from Windows”
magp.ie 