Query regarding Insert Statement!!!!

Поиск
Список
Период
Сортировка
От sandeep bantia
Тема Query regarding Insert Statement!!!!
Дата
Msg-id 20030513135201.9915.qmail@web8205.mail.in.yahoo.com
обсуждение исходный текст
Список pgsql-novice
Hi everybody,
   This would seem a very fundamental doubt to you all
and might've been addressed before too, but I couldn't
find it on the mailing lists, so had to put on the
mailing list.
 My question to all of you is as follows:
 I tried to insert a row into a table of my database
in the following format:
   INSERT INTO TABLENAME SET
(COL_NAME1='VALUE1',COLNAME_NAME2='VALUE2'...);
but this doesn't seem to work and i get the message
that "parse error at or near set"

   I also tried this query,
INSERT INTO TABLENAME SET values
(COL_NAME1='VALUE1',COLNAME_NAME2='VALUE2'...);
but this too doesn't work!!!
I think this type of insert statement is supported in
MySQL,but not very sure about PostGreSQL.

I use postgresql7.2.3 on linux.

Please do reply to my query.
Thanks in advance.
Sandeep!!!

________________________________________________________________________
Missed your favourite TV serial last night? Try the new, Yahoo! TV.
       visit http://in.tv.yahoo.com


В списке pgsql-novice по дате отправления:

Предыдущее
От: roboccc@t-online.de (Bogdan Chytrek)
Дата:
Сообщение: Copy command (bug??)
Следующее
От: micke
Дата:
Сообщение: why are these query results differing?