Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
CREATE TABLE search_terms_new ( search_terms_id mediumint(9) NOT NULL, search_terms varchar(255) NOT NULL, PRIMARY KEY(search_terms_id) ) ENGINE = InnoDB AUTO_INCREMENT = 0 GO ALTER TABLE search_terms_new ADD CONSTRAINT the_unique UNIQUE (search_terms) GO
INSERT IGNORE INTO server_logs.search_terms_new (search_terms_id,search_terms) SELECT LAST_INSERT_ID()+1, search_terms FROM server_logs.search_terms
1 record(s) affected [Executed: 10/28/2013 4:35:49 PM] [Execution: 5s]
0 record(s) affected [Executed: 10/28/2013 4:36:25 PM] [Execution: 4s]
Join the community of 500,000 technology professionals and ask your questions.