MySql- on duplicate key insert with string added
― How to insert from one table to another and on duplicate key append string to new row? If i got table with values: ∙ a ∙ b ∙ c ∙ and want insert tablevith value: ∙ a ∙ i want append string like 'x' so i will get table with values: ∙ a ∙ b ∙ c ∙ xa ∙ 1 Answer INSERT INTO aatestSELECT IF(COUNT(a2.letter)=0,'a','xa')FROM aatest a1LEFT JOIN aatest a2 ON a1.letter = a2.letter OR a2.letter IS NULLWHERE a2.letter = 'a' [...].








