java - SQL 仅替换为一行中的前两列

Question

我目前拥有的是:

PreparedStatement ps = getSQLConnection().prepareStatement(
    "REPLACE INTO " + table + " (uuid,name) VALUES(?,?)"
    );

ps.setString(1, uuid.toString());
ps.setString(2, name.toLowerCase());
ps.executeUpdate();

但是它不仅仅设置索引 1 和 2，而是清除其他列值。如何插入仅包含前 2 个索引的行，并保持其他值不变？

该表是使用以下语句创建的:

"CREATE TABLE IF NOT EXISTS data (" +
"`uuid` varchar(36) NOT NULL," +
"`name` varchar," + 
"`owner` varchar," + 
"`tags` varchar," + 
"PRIMARY KEY (`uuid`));"

Answer 1

来自the documentation :

REPLACE is a MySQL extension to the SQL standard. It either inserts, or deletes and inserts. For another MySQL extension to standard SQL—that either inserts or updates—see Section 13.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”.