From the course: SQL for Testers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create new entries in a table

Create new entries in a table - SQL Tutorial

From the course: SQL for Testers

Start my 1-month free trial

Create new entries in a table

“

- [Instructor] So far, we've been looking at ways to see and analyze data to table. But now it's time to switch gears and take a look at how we can generate data. So if you're testing, you're often going to want to create certain scenarios to see what happens. Maybe you want a certain kind of data to be there, or maybe you just want to have a whole bunch of data in place so that you can test maybe lots of users or lots of products or something else, some other kind of load test in your system. There's a lot of reasons that you might want to create data in a table. But before we go further, I just want to give you a quick word of warning, make sure that when you create data like this, you're not modifying things in a production environment or in another place where those changes can have adverse effects. So with that warning firmly in your mind, let's take a look at a few examples of how we create data in a table. So for this example, let's look at doing it at trying to create a…

Contents