trouble with query - Mailing list pgsql-general
From | Jay |
---|---|
Subject | trouble with query |
Date | |
Msg-id | 411049DD.9090807@cs.uccs.edu Whole thread Raw |
Responses |
Re: trouble with query
|
List | pgsql-general |
hi people, 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
pgsql-general by date: