trouble with query

Поиск
Список
Период
Сортировка
От Jay
Тема trouble with query
Дата
Msg-id 411049DD.9090807@cs.uccs.edu
обсуждение исходный текст
Ответы Re: trouble with query  (Oliver Elphick <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: trash talk
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Updateable Views?