I don't need to specify the id because as part of our contract we made a contract
with a database that says, you assign that.
So I'm going to run this now, INSERT INTO Artist with a name of Led Zeppelin.
And if then we Browse Data and we go look at the artist, it's added the number 1.
Kind of predictable. You can kind of guess where the next one's going to be,
so the next one thing we're going to do is we're going to insert another artist in,
we're going to insert AC/DC in.
And, we inserted that.
Now, if we go take a look at the data again, we got 2.
And if we did a new record here, it would automatically provide this for us, right?
I mean, it would let us change this, but it would want to pick the next number 3.
So what we've done here is both inserted the record,
but we've also established for within this database a new number.
1 means Led Zepplin, and 2 means AC/DC. Okay?
So then, the next thing we're going to do is insert in the Genre,
kind of working outward in, and insert the value Rock and
the value Metal, and now I'm going to show you a little trick here.
You can actually, in this user interface of most of these things,
not just this one, you can usually put more than one command in as long as you
put a semicolon at the end of it.
So I'm going to, if I did that right, semicolon at the end of it.
So I'm going to do an INSERT INTO Genre of Rock and
an INSERT INTO Genre of Metal and I'm going to run the SQL.