MySQL Duplicate a Table – Quick Tip

Looking to duplicate a table into a new table – it is very simple:

   CREATE TABLE `high_risk_old` LIKE high_risk;
   INSERT INTO `high_risk_old` SELECT * FROM `high_risk`;
Advertisements

MySQL Matches INT 0 to all for VarChar

MySQL Matches INT 0 to all for VarChar

I found a strange bug/feature in MySQL which means that if you do a select statement using a INT against a VARCHAR column in matches all of the values in the column which do not start with a number. MySQL claim this is a normal.

Continue reading “MySQL Matches INT 0 to all for VarChar”