Sometimes you'll want to add many values at once to your tables. For example, in a seeder file, you may want to insert several entries in your database at a time for demo and display data.

To do this, we follow the same syntax, except we can seperate each set of values with a comma. Just make sure the final set of values end in a semicolon.

INSERT INTO Users (name, email) VALUES
("Oscar","oscar@email.com"),
("Mario","mario@email.com"),
("Andrea","andrea@email.com");

0 Comments

Top comments

"Please login to view comments"

Join the Conversation!

Subscribing gives you access to the comments so you can share your ideas, ask questions, and connect with others.

Upgrade your account