Insert Multiple Rows In One Statement Jim KnicelyApril 12, 2022 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!