Re: newbie sql question...
От | Vincent Hikida |
---|---|
Тема | Re: newbie sql question... |
Дата | |
Msg-id | 03d101c32414$354de8b0$6601a8c0@HOMEOFFICE обсуждение исходный текст |
Ответ на | newbie sql question... (Jason Ziegler <moo@zigfam.org>) |
Список | pgsql-general |
I'm a newbie too but I believe that you need to do: INSERT INTO table1 ( id, column2, column3 ) values (1,'text stuff','text stuff'); INSERT INTO table1 ( id, column2, column3 ) values (2,'more text stuff','text stuff'); Vincent Hikida, Member of Technical Staff - Urbana Software, Inc. "A Personalized Learning Experience" www.UrbanaSoft.com ----- Original Message ----- From: "Vincent Hikida" <vhikida@inreach.com> To: "Jason Ziegler" <moo@zigfam.org> Sent: Monday, May 26, 2003 10:48 PM Subject: Re: [GENERAL] newbie sql question... > I'm a newbie too but I believe that you need to do: > > INSERT INTO table1 ( id, column2, column3 ) > values (1,'text stuff','text stuff'); > INSERT INTO table1 ( id, column2, column3 ) > values (2,'more text stuff','text stuff'); > > Vincent Hikida, > Member of Technical Staff - Urbana Software, Inc. > "A Personalized Learning Experience" > > www.UrbanaSoft.com > > ----- Original Message ----- > From: "Jason Ziegler" <moo@zigfam.org> > To: <pgsql-general@postgresql.org> > Sent: Monday, May 26, 2003 10:07 PM > Subject: [GENERAL] newbie sql question... > > > > Hello folks, I'm new to this list, and have been putting up with mysql > > for too long, so please forgive me for asking such a newbie question as > > this: > > > > I have a query that works in mysql: > > "INSERT INTO table1 ( id, column2, column3 ) VALUES ( '1', 'text > > stuff', 'text stuff' ), ( '2', 'more text', 'even more text')" > > > > When I try this in postgresql, it won't work: > > "INSERT INTO table1 ( 'id', 'column2', 'column3' ) VALUES ( '1', 'text > > stuff', 'text stuff' ), ( '2', 'more text', 'even more text')" > > > > I think I'm getting the syntax wrong for stringing together multiple > > value sets or something. > > Can anyone point me in the correct direction of how to do this > > properly, please? > > > > Thanks, > > > > jz > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > >
В списке pgsql-general по дате отправления: