Write a postgre SQL statement to insert 3 rows by a single insert statement.
INSERT INTO countries VALUES('C4','India',1001), ('C5','USA',1007),('C6','UK',1003);
Here is the command to see the list of inserting rows :
postgres=# SELECT * FROM countries; country_id | country_name | region_id ------------+--------------+----------- C1 | India | 1002 C2 | USA | C3 | UK | C4 | India | 1001 C5 | USA | 1007 C6 | UK | 1003 (6 rows)
total answers (1)
start bookmarking useful questions and collections and save it into your own study-lists, login now to start creating your own collections.
Here is the command to see the list of inserting rows :
need an explanation for this answer? contact us directly to get an explanation for this answer