INSERT INTO customers (registerNo, custName, firstName, lastName, nationality, gender, age, email, emailConfirm, custRank, initialDay, custPassword, ModiUser) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE registerNo = VALUES(registerNo), custName = VALUES(custName), firstName = VALUES(firstName), lastName = VALUES(lastName), nationality = VALUES(nationality), gender = VALUES(gender), age = VALUES(age), email = VALUES(email), emailConfirm = VALUES(emailConfirm), custRank = VALUES(custRank), initialDay = VALUES(initialDay), custPassword = VALUES(custPassword), ModiUser = VALUES(ModiUser)