Top "Prepared-statement" questions

A Prepared Statement (or parameterized statement) is a precompiled SQL statement that serves to improve performance and mitigate SQL injection attacks.

iOS / sqlite - How to print a prepared sqlite3_stmt to NSLog

I'm having some unexpected results with the data i'm inserting or replacing into my sqlite database. To trouble shoot the …

ios database sqlite prepared-statement nslog
Should I use mysqli_real_escape_string or should I use prepared statements?

Should I use mysqli_real_escape_string or should I use prepared statements? I've seen a tutorial now explaining prepared …

php mysqli prepared-statement mysql-real-escape-string
When to close Prepared Statement

When to close prepared statements in PHP? Example: $query = "insert into web_reviews (title,added_date,reviewer_home_url,read_…

php prepared-statement
Inserting into custom SQL types with prepared statements in java

I have some custom types. They are all basically enums. Here is an example of what they look like: CREATE …

java sql postgresql prepared-statement
Rails 3.2 frequent postgres prepared statement already exists errors

I've been digging around stackoverflow trying to find others who get these prepared statements already exists errors. In most cases …

ruby-on-rails postgresql heroku ruby-on-rails-3.2 prepared-statement
The statement was aborted because it would have caused a duplicate key

I keep getting this error: Error code 20000, SQL state 23505 Insert command failed: The statement was aborted because it would have …

java netbeans prepared-statement derby embedded-database
Java Crosstab - preparedstatement query

I have a typical crosstab query with static parameters. It works fine with createStatement. I want to use preparestatement to …

java postgresql prepared-statement crosstab
Is mysql_real_escape_string() necessary when using prepared statements?

For this query, is necessary to use mysql_real_escape_string? Any improvement or the query is fine ? $consulta = $_REQUEST["…

php mysql mysqli prepared-statement sanitize
pq driver: prepared statement does not exist

I'm trying to connect to a postresql database with the pq driver in Go. When I do it on a …

postgresql go prepared-statement pgbouncer