UNION The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected. UNION ALL The UNION ALL command is equal to the UNION command, except… Read More


I have come across an instance where converting to UTF8 during the MySQL import process does not always “convert to UTF8” even though the table charset is set to UTF8.  The following query will fix a column with data stored latin1 in a utf8 table:  

 … Read More