From: | Jay <jspothar(at)cs(dot)uccs(dot)edu> |
---|---|
To: | General Postgres <pgsql-general(at)postgresql(dot)org> |
Subject: | trouble with query |
Date: | 2004-08-04 02:28:45 |
Message-ID: | 411049DD.9090807@cs.uccs.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-04 02:40:23 | Re: Updateable Views? |
Previous Message | Christopher Kings-Lynne | 2004-08-04 01:32:53 | Re: NOT IN query takes forever |