Tag Info

New answers tagged

0

count lines/records in your textfile import count records after import if count1=count2 then continue tidy up fields (update blablabla set changefield='new' where myfield='badinfo') test tidy up : select count(*) from blablabla where myfield='badinfo' and changefield<>'new' if testTidyUp-count = 0 then cleanup = correct ... continue count records after ...


2

You could use log_output and general_log (USE CAREFUL), for those blessed with MySQL >= 5.1.12: Steps: I've created a new table called new_table: CREATE TABLE new_table ( id int(11) NOT NULL, text varchar(45) DEFAULT NULL, text2 varchar(45) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I've created a new log table called ...



Top 50 recent answers are included