Named parameters for MySQL inserts / updates

[SebastienMelki]

What do you want to change?

I'm trying to generate code based on queries like this

-- name: InsertPurchaseGuid :exec INSERT INTO purchase_guids (external_id, guid, created_at, updated_at, partner_id, payment_method_id) VALUES (:external_id, :guid, :created_at, :updated_at, :partner_id, :payment_method_id);

So that I can use the NamedExec function of the mysql driver. But whenever I run sqlc generate I get this error

db/queries/subs/insert_purchase_guid.sql:3:10: syntax error near ":external_id, :guid, :created_at, :updated_at, :partner_id, :payment_method_id);"

Is this not supported at all? Or am I doing it wrong?

Thank you!

What database engines need to be changed?

MySQL

What programming language backends need to be changed?

Go

[orisano]

MySQL does not support NamedParameter

[SebastienMelki]

MySQL does not support NamedParameter

Hello, do you mean it's not supported in sqlc? Because MySQL itself does support named parameters just fine as far as my testing goes. I used the .NamedExec of the sql driver in go, and got the expected results