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 ...
- 33
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 ...
- 31
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 ;
- 142
Only top scored, non community-wiki answers of a minimum length are eligible