Shell script error
Hi,
I have the following table in MYSQL: (the structure looks broken in this forum but if you copy/paste it into notepad, it'll look right):
+----------------------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------+-----------------------+------+-----+---------+----------------+
| id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |
| hash | varchar(32) | NO | | | |
| local_data_template_rrd_id | mediumint(8) unsigned | NO | MUL | 0 | |
| local_data_id | mediumint(8) unsigned | NO | MUL | 0 | |
| data_template_id | mediumint(8) unsigned | NO | MUL | 0 | |
| t_rrd_maximum | char(2) | YES | | NULL | |
| rrd_maximum | varchar(20) | NO | | 0 | |
| t_rrd_minimum | char(2) | YES | | NULL | |
| rrd_minimum | varchar(20) | NO | | 0 | |
| t_rrd_heartbeat | char(2) | YES | | NULL | |
| rrd_heartbeat | mediumint(6) | NO | | 0 | |
| t_data_source_type_id | char(2) | YES | | NULL | |
| data_source_type_id | smallint(5) | NO | | 0 | |
| t_data_source_name | char(2) | YES | | NULL | |
| data_source_name | varchar(19) | NO | | | |
| t_data_input_field_id | char(2) | YES | | NULL | |
| data_input_field_id | mediumint(8) unsigned | NO | | 0 | |
+----------------------------+-----------------------+------+-----+---------+----------------+
And am trying to run the following command:
INSERT INTO data_template_rrd (id, hash, local_data_template_rrd_id, local_data_id, data_template_id, t_rrd_maximum, rrd_maximum, t_rrd_minimum, rrd_minimum, t_rrd_heartbeat, rrd_heartbeat, t_data_source_type_id, data_source_type_id, t_data_source_name, data_source_name, t_data_input_field_id, data_input_field_id) VALUES (138, '', 102, 37, 49, on , 0, on, 0, on, 600, on, 2, on, 'Internal', NULL, 0);
(the ID=138 is being auto generated by a line of code:
NEXTAID=`$mysqlcmd -L -N --batch -u$mysqluser -p$mysqlpassword $database -e "SELECT MAX(id) as max_id from data_template_rrd;"` )
But I am getting an error message:
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 'on , 0, on, 0, on, 600, on, 2, on, 'Internal', NULL, 0)' at line 1
Can someone please help me fix it?
Thanks
Last edited by tezarin; 10-22-2009 at 02:36 PM..