The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
55 views

DBO execute returns true but doesn't execute

I am having a bit of trouble with some of my code. This is the code: $STMT3 = $PDO->prepare(' INSERT INTO `lotteries_entries` (steamID, lottery_id) VALUES (:STEAMID, :ID); UPDATE ...
1
vote
1answer
71 views

Benefits of using prepared statements in stored procedures?

Except from helping avoid SQL injection, what are the benefits - if any - of using prepared statements inside a store procedure (assume query is only executed once in the procedure)? Does the engine ...
3
votes
0answers
68 views

Tagged questions

I have similar to StackExchange network that utilises tagged questions. In my web application Users also can find questions by tags. The query below returns a set of tagged questions: SELECT ...
0
votes
0answers
38 views

How to execute a mysql prepared statement on different database?

Is there an option to execute a prepared statement on a different database? ex: USE @database PREPARE pstmt FROM @stmt; EXECUTE pstmt; DEALLOCATE PREPARE pstmt; I need to set the database ...
0
votes
0answers
23 views

Mysql native driver or just use pdo

I am now exploring on prepared statement. I was using the codes below. $link = new mysqli(dbHost, dbUser, dbPassword, dbDatabase); if($link->connect_error) { die('bind_param() failed: ' . ...
0
votes
0answers
161 views

Performance: Interleaving several statement handles in MySQL

Does interleaving several statement handles slow the system down? Example (Perl): $sth1->execute(...); $sth2->execute(...); $sth1->execute(...); $sth2->execute(...); (interleaved) vs ...
0
votes
0answers
184 views

Using prepared statements in libpqxx with variable numbers arguments

I am trying to do some streamlining of a PostgreSQL database application. I am collecting data in a real-time setting using a Windows application and libpqxx. I would like to look into using ...
0
votes
0answers
2k views

How can I create a view in a stored procedure on MySQL?

I am trying to dynamically create views based on an SQL query and have a trigger recreate them when the fields in the view are to change. When I call the procedure I end up with a permission denied ...