Mysql query:
How to change the query into postgresql?
INSERT into tablename SET a=10, b=20, c=30
Add a comment
|
2 Answers
PostgreSQL does not support syntax INSERT...SET (mysql does).
But another systax can be something you need:
with full fields:
INSERT into tablename
SELECT 10 AS a, 20 AS b, 30 as c;
with specific fields:
INSERT into tablename (b, c)
SELECT 20 AS b, 30 as c;
1 Comment
Enginer
This solution not working
Insert Query:
INSERT into tablename(a,b,c) values (10,20,30)
Update Query:
update tablename SET a=10, b=20, c=30 where <conditions...>
3 Comments
selva
i want this query in postgresql
Vivek S.
@selva This is the query, you're confused with something that missing in the question and my answer is the way to insert/update data in any DB including PostgreSQL
Peter Nixey
To add some caution for anyone reading this - if you use that
update statement then it will set those values for ALL records in your database. Not just a new record. It's SUPER dangerous