2012/11/23 10:49 +0530, Girish Talluru
I have a scenario where I have to screen a huge bunch of records for in db
using certain rules. I have done in traditional php style record by record
and it took 90 mins for 4000 records. I have 800k - 900k records in
production which might possibly lead to
when I call a
stored procedure does the control get backs immediately to the php script?
No, sprocs wil lvery likely slow you down.
Probably best to split the job into several part-tasks (i) read rows into a
work buffer, (ii) walk the work buffer and mark done rows, (iii) walk the done
list
Hello all,
I would like to create a stored procedure that does the following:
1. Accepts 4 values as parameters
2. SELECTS 1 record (LIMIT 1) from a table where the 4 parameters match fields
in that table
a. If a record was returned then UPDATE the table
b. If a record was not
SELECT id INTO @row_id FROM myTable WHERE blah blah LIMIT 1;
Source
http://dev.mysql.com/doc/refman/5.5/en/select-into-statement.html
On Sep 21, 2011, at 2:23 PM, Brandon Phelps wrote:
Hello all,
I would like to create a stored procedure that does the following:
1. Accepts 4 values as
Ah ha! Thanks Derek. I thought INTO was used strictly for inserting the
selected records into another table.
Much appreciated.
On 09/21/2011 02:34 PM, Derek Downey wrote:
SELECT id INTO @row_id FROM myTable WHEREblah blah LIMIT 1;
Source
I've got a stored procedure I'm trying to convert from MS SQL. I've gotton
so far with it, but it's complaining about the INSERT command. It's a very
simple stored procedure, so it should easy to figure out, but I'm not
familiar with the MySQL Stored Procedure syntax. If someone can point out
Jesse Castleberry [EMAIL PROTECTED] wrote on 11/07/2005 01:26:59 PM:
I've got a stored procedure I'm trying to convert from MS SQL. I've
gotton
so far with it, but it's complaining about the INSERT command. It's a
very
simple stored procedure, so it should easy to figure out, but I'm not
Jesse,
BEGIN
INSERT INTO Campers (FirstName, LastName, UserName, Password) VALUES
(cFirstName, cLastName, cUserName, cPassword) // ERROR RIGHT HERE.
AddedID = LAST_INSERT_ID()
END;
First, there's a right parenthesis missing. Second, the expression
AddedID = LAST_INSERT_ID()
will evaluate