If you are using an older version of SingleStore, or using SingleStore with Audit Logging enabled, SingleStore does not support server-side prepared statements. Instead, many client drivers support a configuration option to allow client-side prepared statements. This configuration option may also be referred to as client-side prepared statement emulation or parameter interpolation. You can use the same code in your application, but change a flag in the client driver configuration. For example:

• In the MySQL Connector/J (JDBC) driver, set useServerPrepStmts=false, which is the default configuration.

• In MariaDB Connector/J, set useServerPrepStmts=false.

• In ODBC, set no_ssps=1.

• In the Go MySQL driver, set interpolateParams=true.

• In PHP PDO, set PDO::ATTR_EMULATE_PREPARES=TRUE.

In many other databases, server-side prepared statements provide performance advantages, but SingleStore already compiles and caches query plans internally, so SingleStore does not need server-side prepared statements to get most of those performance advantages.