i am using mysql and i am having the following problem....
I know this is not the correct to ask this problem. but i am need of help urgently thats why i posted this here.
but please help
i have a table with the following fields .when i try to enter data i get the following error.any help would b
+---------------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+---------------+------+-----+---------+-------+
| human_subj | char(3) | YES | | NULL | |
| human_subj_approval_date | timestamp(6) | YES | | NULL | |
| animal_subj | char(3) | YES | | NULL | |
| animal_subj_approval_date | timestamp(6) | YES | | NULL | |
| toxic | char(3) | YES | | NULL | |
| toxic_approval_date | timestamp(6) | YES | | NULL | |
| curriculum_change | char(3) | YES | | NULL | |
| compensate_employee | char(3) | YES | | NULL | |
| course_release | char(3) | YES | | NULL | |
| subcontract | char(3) | YES | | NULL | |
| sponsor_org | char(3) | YES | | NULL | |
| additional_space | char(3) | YES | | NULL | |
| search_waiver | char(3) | YES | | NULL | |
| generate_income | char(3) | YES | | NULL | |
| classified | char(3) | YES | | NULL | |
| suspended | char(3) | YES | | NULL | |
| institute_affected | char(3) | YES | | NULL | |
| tution_included | char(3) | YES | | NULL | |
| tenure | char(3) | YES | | NULL | |
| pi_assurance | char(3) | YES | | NULL | |
| pi_sign | char(40) | YES | | NULL | |
| pi_date | timestamp(6) | YES | | NULL | |
| co_pi_assurance_1 | char(3) | YES | | NULL | |
| co_pi_sign | char(40) | YES | | NULL | |
| co_pi_1_date | timestamp(14) | YES | | NULL | |
| co_pi_assurance_2 | char(3) | YES | | NULL | |
| co_pi_sign2 | char(40) | YES | | NULL | |
| co_pi_2_date | timestamp(14) | YES | | NULL | |
| co_pi_assurance_3 | char(3) | YES | | NULL | |
| co_pi_sign3 | char(40) | YES | | NULL | |
| co_pi_3_date | timestamp(14) | YES | | NULL | |
| co_pi_assurance_4 | char(3) | YES | | NULL | |
| co_pi_sign4 | char(40) | YES | | NULL | |
| co_pi_4_date | timestamp(14) | YES | | NULL | |
| proj_id | int(5) | YES | | NULL | |
+---------------------------+---------------+------+-----+---------+-------+
35 rows in set (0.00 sec)
when i enter the following data
INSERT INTO form VALUES ('yes',,'yes',,'yes',,'yes','yes','yes','yes','yes','yes','yes','no','yes','no','yes','yes','yes','yes','john',,'',,,'','',,'','',,'','',,'');
i get the following error
ERROR 1064: 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 ''yes',,'yes',,'yes','yes','yes','yes','yes','yes','yes','no','y
please help! thanks jay
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
