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
Category: MySQL
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.
