Mysql - Datensatz kopieren und Datum ändern

[EKKi]

Mahlzeit tomgk,

Probier mal (ungetestet): INSERT INTO Tabelle_A (X,Y,Z,date)
VALUES (SELECT X,Y,Z, date as "2010-01-01 00:00" FROM Tabelle_A AS TA
WHERE TA.date like "%2010-07-14%")

Sinnvoller wäre

INSERT INTO Tabelle_A (X, Y, Z, date)  
VALUES (  
        SELECT X  
        ,      Y  
        ,      Z  
        ,      "2010-01-01 00:00" AS date  
          FROM Tabelle_A AS TA  
         WHERE TA.date LIKE "%2010-07-14%"  
       )

MfG,
EKKi