database - MySQL v5.7.4 - Is there no longer a way to remove duplicates with "unique index"? -


so apparently after mysql v5.7.4, keyword ignore no longer supported, nukes useful duplicate-removing query:

alter ignore table labs  add unique index nodupes (ruid, test_sname, test_value, units, ref_range, entry_date);

everywhere i've looked notes discontinued support of ignore, doesn't suggest replacement.

is there still simple way utilize power of unique index remove duplicates without using ignore after mysql v5.7.4?

many people consider thing creating index not delete records underlying table. 1 method use temporary table, truncate, , insert:

create temporary table tokeep      select distinct ruid, test_sname, test_value, units, ref_range, entry_date      labs;  truncate table labs;  insert labs(ruid, test_sname, test_value, units, ref_range, entry_date)     select ruid, test_sname, test_value, units, ref_range, entry_date     tokeep;

note: version assumes these columns in table. if there other columns, similar logic work.


-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

python 3.x - PyQt5 - Signal : pyqtSignal no method connect -

following example in doc found on sourceforge faced error. from pyqt5.qtcore import pyqtsignal, pyqtslot def setsignal(): signal = pyqtsignal() signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered") results in attributeerror: 'pyqt5.qtcore.pyqtsignal' object has no attribute 'connect' as mentioned in docs linked, signal needs defined on class level: class foo(qobject): signal = pyqtsignal() def connectsignal(): self.signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered")
Read more