Insert Multiple Rows In One Statement

Need to insert a bunch of rows? No problem, you can do it in a single INSERT SQL statement in YugabyteDB!

				
					
yugabyte=# CREATE TABLE my_favorite_comedians (name VARCHAR(100));
CREATE TABLE

yugabyte=# INSERT INTO my_favorite_comedians VALUES ('Bob Newhart'), ('Redd Foxx'), ('Norm Macdonald'), ('Steven Wright'), ('Gilbert Gottfried');
INSERT 0 5

yugabyte=# SELECT * FROM my_favorite_comedians;
       name
-------------------
 Norm Macdonald
 Bob Newhart
 Steven Wright
 Gilbert Gottfried
 Redd Foxx
(5 rows)

Have Fun!