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 ...
user avatar
  • 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 ...
user avatar
  • 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 ;
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible