On 02/25/2018 02:01 AM, Suliman wrote:
What about string interpolation like:conn.exec("INSERT INTO table_name VALUES ({i}, {s})"); ? Instead of: conn.exec("INSERT INTO table_name VALUES (?, ?)", i, s);
The syntax is purely, 100% server-side. Mysql-native just passes the whole string, question marks and all, straight off to the server. So whatever syntax the server supports, mysql-native supports. Whatever the server doesn't, mysql-native doesn't.
I've heard about a MySQL (I think) syntax like this: "INSERT INTO table_name VALUES (:i, :s)" But I haven't given it a try, and I don't know about its compatability.
