Hassle-free live chat software re-imagined for business growth. 2 users, always free.
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]
|trying to get the non-distinct values to show in a result set||1||37|
|html input clean up||3||47|
|configure dependency in POM for new database||3||17|
|Determining creation & modification dates on MySQL tables||4||8|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!