Re: ERROR 1136 - driving me nuts
>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.
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.