Results 1 to 8 of 8
Dec 13, 2012, 03:12 #1
Key unique string prevents duplicate rows
I need your help.
This is my query in mysql.
UPDATE `tblm` SET UniqueString = NULL; UPDATE `tblm` SET UniqueString = TRIM( REPLACE ( CONCAT( TES, idNode, idLINE, REPLACE (LINE_NAME, '`', '') ), ' ', '' ) )
[Err] 1062 - Duplicate entry '60138282ARGO' for key 'UniqueString'