When using Server Connect’s Database Insert step, I would find it very helpful to be able to choose INSERT IGNORE INTO, in addition to the existing INSERT INTO. I often have to insert a large number of IDs into a table - perhaps a join table in a many:many relationship. The target table may only co…

Are you using the server action validate Data feature to do the checks or are you doing it with custom code?

I’m not using any checks in Wappler. I’m using a composite primary key, so the validation is left to MySQL. All that’s needed is for inserts to be ignored if a duplicate would be created. I would often want this to apply when doing multiple inserts - simply done with the ‘IGNORE’ option (which I’ve …

The IGNORE options is not in the SQL ANSI standard, it is a MySQL only feature.

Thanks - I didn’t know that. I’ll have to check for changes when new Wappler releases are made, but I don’t think SqlBuilder.php changes very often. A list of modified files with new releases would be very helpful. This cropped up in a thread recently so hopefully will be available at some point.

Is it still the policy of Wappler that IGNORE won’t be supported because it is mySql specific? It sure would be great to have an Ignore option on Insert, especially Batch insert. Related, supporting Upsert would also be nice. INSERT INTO my_table (id, col1, col2) VALUES (1, 'a', 'b') ON DUPLICATE…

I'm slipping in my suggestion on this matter: [image] DB SC Actions - Add Upsert (postgres) and Insert / Update Duplicate Key MySql Feature Request Also, to complement, give us an option to select which fields we want to update… For example, when inserting…

Option for inserting records: INSERT IGNORE INTO

Feature Request

Apple October 3, 2025, 4:50pm 7

I'm slipping in my suggestion on this matter: