Simon
Simon
Explore posts from servers
DDenoTtRPCTTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Simon on 2/8/2024 in #help
Alter type enum column ending in replace rather than alter
No description
2 replies
DTDrizzle Team
Created by Simon on 2/1/2024 in #help
ON DUPLICATE KEY UPDATE with bulk insert?
INSERT INTO beautiful (name, age)
    VALUES
    ('Helen', 24),
    ('Katrina', 21),
    ('Samia', 22),
    ('Hui Ling', 25),
    ('Yumie', 29)
    AS new
ON DUPLICATE KEY UPDATE
    age = new.age
    ...
INSERT INTO beautiful (name, age)
    VALUES
    ('Helen', 24),
    ('Katrina', 21),
    ('Samia', 22),
    ('Hui Ling', 25),
    ('Yumie', 29)
    AS new
ON DUPLICATE KEY UPDATE
    age = new.age
    ...
any way to create such a query?
3 replies