52 lines
1.2 KiB
SQL
52 lines
1.2 KiB
SQL
INSERT INTO Bauteile ( TXLCode, Messdatum, Rauheitsdatum, Lieferbox, OL1, OL2, OW1, OW2, R11, R12, R13, R21, R22, R23, R31, R32, R33, R41, R42, R43, CW, LW, MessComm, RauComm )
|
|
VALUES
|
|
(
|
|
"${e['TXLCode']}",
|
|
"${e['MessDate']}",
|
|
"${e['RauDate']}",
|
|
"${e['Lieferbox']}",
|
|
${e['OL1']},
|
|
${e['OL2']},
|
|
${e['OW1']},
|
|
${e['OW2']},
|
|
${e['R11']},
|
|
${e['R12']},
|
|
${e['R13']},
|
|
${e['R21']},
|
|
${e['R22']},
|
|
${e['R23']},
|
|
${e['R31']},
|
|
${e['R32']},
|
|
${e['R33']},
|
|
${e['R41']},
|
|
${e['R42']},
|
|
${e['R43']},
|
|
${e['LW']},
|
|
${e['CW']},
|
|
"${e['InfoMessComm']}",
|
|
"${e['InfoRauComm']}"
|
|
) ON DUPLICATE KEY UPDATE
|
|
TXLCode = "${e['TXLCode']}",
|
|
Messdatum = "${e['MessDate']}",
|
|
Rauheitsdatum = "${e['RauDate']}",
|
|
Lieferbox = "${e['Lieferbox']}",
|
|
OL1 = ${e['OL1']},
|
|
OL2 = ${e['OL2']},
|
|
OW1 = ${e['OW1']},
|
|
OW2 = ${e['OW2']},
|
|
R11 = ${e['R11']},
|
|
R12 = ${e['R12']},
|
|
R13 = ${e['R13']},
|
|
R21 = ${e['R21']},
|
|
R22 = ${e['R22']},
|
|
R23 = ${e['R23']},
|
|
R31 = ${e['R31']},
|
|
R32 = ${e['R32']},
|
|
R33 = ${e['R33']},
|
|
R41 = ${e['R41']},
|
|
R42 = ${e['R42']},
|
|
R43 = ${e['R43']},
|
|
CW = ${e['LW']},
|
|
LW = ${e['CW']}, M
|
|
essComm = "${e['InfoMessComm']}",
|
|
RauComm = "${e['InfoRauComm']}"; |