MySQL- Allowing Access to Root Remotely
MySQL includes all the basic methods needed to secure your user accounts. However, the syntax and style used to manage it is often confusing to MySQL novices. Here are a…
Read moreMySQL – DateTime vs. TimeStamp – When to use?
This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…
Read moreMySQL How to delete duplicate records and rows of data
The fastest and easiest way to delete duplicate records is my issuing a very simple command. alter ignore table [tablename] add unique index `unique_index` ([fieldname]) What this does is create…
Read more