zio / zio-quill

Compile-time Language Integrated Queries for Scala
https://zio.dev/zio-quill
Apache License 2.0
2.15k stars 348 forks source link

How can I use mysql's "replace into" #687

Open ddyycao opened 7 years ago

ddyycao commented 7 years ago

REPLACE INTO table (unique_column,num) VALUES ('$unique_value',$num);

Is there any way I can use this statement in Quill?

jilen commented 7 years ago

Infix should work

ddyycao commented 7 years ago

Is there any examples? I don't see Infix has the power to replace some part of a sql

jilen commented 7 years ago

Something like db.run(infix"REPLACE INTO table (unique_column,num) VALUES ($unique_value,$num))

ddyycao commented 7 years ago

I hope there is a better way to do this I dont want to type the whole sql

Frietziek commented 6 years ago

So, there is not support for mysql replace en Quill yet?