Difference between revisions of "INSERT INTO"
Jump to navigation
Jump to search
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
* https://www.postgresql.org/docs/current/sql-insert.html | * https://www.postgresql.org/docs/current/sql-insert.html | ||
[[INSERT]] INTO ... VALUES ... | [[INSERT]] INTO ... VALUES ... | ||
+ | |||
+ | == Errors == | ||
+ | * <code>[[ERROR 21000 ON CONFLICT DO UPDATE command cannot affect row a second time]]</code> | ||
Line 6: | Line 9: | ||
* [[IntegrityError]] | * [[IntegrityError]] | ||
* [[varchar]] | * [[varchar]] | ||
+ | * [[ON CONFLICT DO UPDATE]] | ||
+ | * [[IMPORT INTO]] | ||
== See also == | == See also == | ||
+ | * {{INSERT}} | ||
* {{SQL}} | * {{SQL}} | ||
[[Category:SQL]] | [[Category:SQL]] |
Latest revision as of 17:37, 18 August 2024
INSERT INTO ... VALUES ...
Errors[edit]
Related[edit]
See also[edit]
INSERT
- SQL, NewSQL, RDMS: GraphQL (2015), SQLite,
select, insert
,select count
, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables
,EXPLAIN
, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS
, Unique constraint,.sql
Advertising: