trouble with query

[Jay]

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','y es','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

[Oliver Elphick]

On Wed, 2004-08-04 at 03:28, Jay wrote:

hi people,
i am using mysql and i am having the following problem....
I know this is not the correct to ask this problem.
Surely a MySQL mailing list could have answered this? I thought they
had good community support.
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 ....
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','y es','john',,'',,,'','',,'','',,'','',,'');

i get the following error
ERROR 1064: You have an error in your SQL syntax.

Even MySQL doesn't accept that kind of thing!

You have doubled commas at several places in the VALUES list. I suppose
those are meant to be nulls - you should specify NULL instead of nothing
at all:

INSERT INTO form VALUES
('yes',NULL,'yes',NULL,'yes',NULL,'yes',...);

The way you have written it is bad practice any way. You should use
specific column names rather than relying on the current order in the
table:

INSERT INTO form (human_subj, animal_subj, toxic,...)
VALUES ('yes','yes','yes',...);

This will continue to work even if the table's column order changes for
some reason.
--
Oliver Elphick ol**@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"And not only so, but we glory in tribulations also;
knowing that tribulation worketh patience; And
patience, experience; and experience, hope."
Romans 5:3,4
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html