1
vote
Searching and deleting MySQL records after insert with stored procedure
For anyone reading this in the future. I have resolved it - after four days!
In essence, by inserting the new record using a stored procedure, during which we create a RecordDate by setting a ...
1
vote
Accepted
Temporarily disable SELECT for one table (during an update)
Sorry for the late entry, but I was testing out the direction that David Browne pointed out — and it works just as needed!
A more intrusive method is to put the database in SINGLE USER mode killing ...
1
vote
WEHRE IN array values using stored procedure
Try adding nums in brackets so it can complete the required syntax.
DELIMITER //
CREATE PROCEDURE test (nums ARRAY(INT))
AS
BEGIN
ECHO SELECT * FROM t WHERE num
IN(nums);
END //
DELIMITER ;
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
stored-procedures × 1590sql-server × 716
mysql × 379
t-sql × 151
oracle × 107
sql-server-2008 × 95
postgresql × 93
performance × 87
sql-server-2012 × 79
trigger × 75
sql-server-2008-r2 × 65
permissions × 65
sql-server-2016 × 56
functions × 56
sql-server-2014 × 55
plsql × 55
dynamic-sql × 46
transaction × 37
query-performance × 36
sql-server-2005 × 35
optimization × 33
parameter × 31
view × 29
cursors × 29
db2 × 28