Results 1 to 3 of 3
Thread: stored procedure MySQL
Hybrid View
-
12th April 2011 17:37 #1
stored procedure MySQL
, MySQL, stored procedure .
. . - . , .
"monitoring" "readings".Code:mysql> delimiter // mysql> CREATE PROCEDURE readtemps (devname varchar(20),temp varchar(10),humid va rchar(10),dewpoint varchar(10)) -> BEGIN -> insert into 'monitoring'.'readings' ('date_','time_','temp','humidity','d ewpoint','device') values (curdate(),curtime(),temp,humid,dewpoint,devname); -> END -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''moni toring'.'readings' ('date_','time_','temp','humidity','dewpoint','device') ' at line 3
MySQL 5.0.51CPU: C2D E8400 + CoolerMaster Hyper 212 Plus | MB: Asus P5K | RAM: 4GB Transcend AxeRam | VC: Asus EAH4850 + AC Accelero S1 rev. 2 | Case: Antec SLK3000B | PSU: AC Fusion 550R | : Altec Lansing VS2421 (2.1)
-
12th April 2011 18:33 #2Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
Code:insert into 'monitoring'.'readings' ('date_','time_','temp','humidity','d ewpoint','device') values (curdate(),curtime(),temp,humid,dewpoint,devname);
Code:insert into `monitoring`.`readings` (`date_`,`time_`,`temp`,`humidity`,`dewpoint`,`device`) values (curdate(),curtime(),temp,humid,dewpoint,devname);
-
13th April 2011 14:46 #3
! ,
.
CPU: C2D E8400 + CoolerMaster Hyper 212 Plus | MB: Asus P5K | RAM: 4GB Transcend AxeRam | VC: Asus EAH4850 + AC Accelero S1 rev. 2 | Case: Antec SLK3000B | PSU: AC Fusion 550R | : Altec Lansing VS2421 (2.1)




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in