sql statements
От
David Warren
Тема
sql statements
Дата
Msg-id
005201bf6e80$4e97be60$0600a8c0@pams.com
Список
Дерево обсуждения
sql statements "David Warren" <exec@shreve.net>
Re: [SQL] sql statements Tom Lane <tgl@sss.pgh.pa.us>
UPDATE table1 SET val1 = 'test', SET val2 = 'test' WHERE recnum=1;
This statement doesn't work for me. If I use only one SET per statement it does. Is this supposed to be this way?
Also, the statement INSERT INTO table1 (val1, val2, ..., val68) VALUES ('test','test',...,'test') gives me an error as well. There are 68 elements I am trying to add in that one statement. If I trim it down to 30 or so it is fine. Is it supposed to be this way? The same statement will load into a MySQL database without any problems at all so I know there are no errors in the statement syntax.
В списке pgsql-sql по дате отправления