MySQL Forums
Forum List  »  Stored Procedures

Re: ERROR 1136 - driving me nuts
Posted by: Per-Erik Martin
Date: November 04, 2005 03:22AM

>INSERT INTO network_hour (MAC, rx, tx, snr, rtt) values(MAC, avg_rx, avg_tx, avg_snr, avg_rtt);


The values are not defined. They are not local variables in the procedures.

I guess you really want to declare them as variables and use SELECT ... INTO, rather than naming the fiels with "AS".


pem, Senior Software Dev., MySQL AB



Edited 1 time(s). Last edit at 11/04/2005 03:28AM by Per-Erik Martin.

Options: ReplyQuote


Subject
Views
Written By
Posted
10105
November 03, 2005 01:48PM
Re: ERROR 1136 - driving me nuts
5607
November 04, 2005 03:22AM


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.