row_count() check problem

Question

veledrom 32 Master Poster

15 Years Ago

Hi,
I deliberately do mistake on line INSERT INTO table2....... but, it still commits despite variable of rowcount is set to 0. How can solve it?

Thanks

BEGIN
DECLARE rowcount INT;					
INSERT INTO table1 ………					
SELECT row_count() INTO rowcount;

IF (rowcount=1) THEN
    SET rowcount=0;
    INSERT INTO table2 ……………..
    SELECT row_count() INTO rowcount;

    IF (rowcount=1) THEN
        COMMIT;
    ELSE
       ROLLBACK;
    END IF;
END IF;
END

mysql

2 Contributors
1 Reply
104 Views
1 Year Discussion Span
Latest Post 14 Years Ago Latest Post by ndowens

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ndowens 0 Newbie Poster · Answer 1 · 2010-02-23T14:23:34+00:00

Hi,
I deliberately do mistake on line INSERT INTO table2....... but, it still commits despite variable of rowcount is set to 0. How can solve it?
Thanks
BEGIN
DECLARE rowcount INT;					
INSERT INTO table1 ………					
SELECT row_count() INTO rowcount;

IF (rowcount=1) THEN
    SET rowcount=0;
    INSERT INTO table2 ……………..
    SELECT row_count() INTO rowcount;

    IF (rowcount=1) THEN
        COMMIT;
    ELSE
       ROLLBACK;
    END IF;
END IF;
END

I believe it to be because you put SET rowcount=0;