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`;
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`;
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.