Reference: https://bytes.com/topic/mysql/answers/746696-create-mysql-table-field-headings-line-csv-file
Category: SQL
MySQL – Get Max Length of Column
Similar to Max Length of Data In Column – MSSQL this query will do the same for MySQL Replace host (column) along with hosts (table) with what you’d like to check
PHP WordPress – Use Radius Server Login
Securing WordPress with Radius Server login. This project was created in mind to help secure WordPress but allow users an easier way to securely login without having to have a really long password to remember. While I do not go into creating the Radius server you can go to http://www.radiusdesk.com/getting_started/install_ubuntu_nginx…
Install SQL PowerShell Tools
To install the 2014 PowerShell tools, the script below will help make it a bit easier. First all downloads are referenced from this URL (specific for SQL 2014) http://www.microsoft.com/en-ca/download/details.aspx?id=42295 I use Windows 64-Bit so if you use 32-Bit make sure you update your links Reference: http://www.jbmurphy.com/2014/01/16/quickly-install-the-sql-powershell-toolls-on-your-local-machine/
MySQL Procedure Get WordPress Site Name
If you manage many WordPress site databases it can get a bit crazy to know which site goes with what database but it gets more “fun” when you have a network site, below I attempt to help document some ways to help. This first example is a rather long process…
WordPress Database Information
I plan to work more on this as it is rather nasty but as a work in progress notepad if you will this is the spot for now. GitHub: https://gist.github.com/dkittell/f9080101d66834910dfd
MySQL Server Information
SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc. SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc. References: http://stackoverflow.com/questions/3939803/how-to-get-mysql-server-info-using-command-line
Remove Last N Characters From Column
Recently in a project to list all the plugins in a WordPress site with their versions I had accidently added .0 on to various rows in error. This script was very helpful to correct this error Reference: http://stackoverflow.com/questions/10470471/delete-last-n-characters-from-field-in-a-sql-server-database
Version Delimiter
Reference: Laurence @ http://stackoverflow.com/questions/13315756/how-to-compare-sql-strings-that-hold-version-numbers-like-net-system-version-cl