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 a
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
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 WHERE LIMIT 1;
Source
http://dev.mysql.com/doc/refman/5.5/en/select-into-statement
SELECT id INTO @row_id FROM myTable WHERE 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 param
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
"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
