MySQL Forums
Forum List  »  Stored Procedures

Re: Stored procedures - why does this fail ????
Posted by: takashi_949
Date: February 13, 2006 03:18PM

Andrew, I agree whole heartedly with you advice - Infact I have decided to come into this forum for advice, rather than asking people who 'claim' to be database gurus ;-).

Incidentally, I still can't seem to get the insert part of the proc to work - it updates fine, but the inserts still don't work, although when I enter the SQL at the CLI, the table is inserted:

mysql> select * from user_whois ;
+-----+-------+-------+
| uid | mktid | expid |
+-----+-------+-------+
| 1 | 2 | 2 |
| 1 | 3 | 3 |
| 1 | 4 | 5 |
| 2 | 1 | 1 |
| 2 | 2 | 1 |
| 2 | 5 | 4 |
| 3 | 5 | 4 |
+-----+-------+-------+
7 rows in set (0.05 sec)

mysql> call sp_addWhoisInfo(1,1,2) ;
Query OK, 0 rows affected, 1 warning (0.01 sec)

Why is there a warning?, and could anyone please tell me how I can access details (i.e. msg, err level etc) about thi warning?


This is what happens when I run the SQL command at the CLI:

mysql> insert into user_whois values (1,1,2) ;
Query OK, 1 row affected (0.04 sec)

mysql> select * from user_whois ;
+-----+-------+-------+
| uid | mktid | expid |
+-----+-------+-------+
| 1 | 1 | 2 |
| 1 | 2 | 2 |
| 1 | 3 | 3 |
| 1 | 4 | 5 |
| 2 | 1 | 1 |
| 2 | 2 | 1 |
| 2 | 5 | 4 |
| 3 | 5 | 4 |
+-----+-------+-------+
8 rows in set (0.00 sec)


Look forward to your help. Thanks

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.