Now if you notice, this is a maximum of 20 characters here. This is a maximum of 20 characters here and then right here I have included a space. As such, 20 plus 20 plus a space is going to have a maximum of 51 characters. Well, 41 characters, but I'm adding a 10 character buffer, if you will, that I don't really need. I could've made this 41, but I made it 51, making it nice and wide. What's going to end up happening is every time I enter a first name and last name, it will automatically generate. You see this generated always as? It's going to generate a full name that's going to contain the first name, whatever I entered in the first name plus a space plus whatever I entered in the last name as a contact full name. It's also going to designate the cust ID as a primary key, which means it's going to be indexed by itself so that it's searchable very, very quickly. Cust ID itself is going to be a number that will be generated by default all by itself which means that I won't have to enter it. Let me show you what all this means if I click on "Customer". Look what it says here, cust ID. There is the next val. Essentially, default value's going to be 1. It's going to start with one and keep going 2, 3, and 4. It says right here, full name is a combination or concatenation of first name and last name. So let me show you what this turns out to be like. If I trash this and I say insert into customer and I say that I want to insert custname, contact_fname, contact_lname, and then I'm going to say that I'm going to insert values and I'm going to say custname is going to be ABC Corp, and I'm going to say contact Adam, Johnson. It's customer, not customers. Let's try that again. Look over here. I entered in ABC Corp, Adam, and Johnson. It inserted in the cust ID by itself and it concatenated Adam and Johnson by itself, I didn't do that, into contact full name. That's because of my definition of the table. Let's take a look at this here. If I do insert into customer and I say that I want to insert custname, contact_fname, contact_lname, and then I say values, and I say, CBS Corp, and then I say James, Joyce and add it. Let me see what happens here when I do a select star from customer. Here you go. James, Joyce and it concatenates James Joyce, and here's a second cust ID. I didn't add the cust ID, it did that. I didn't add that contact full name, it did that. So I'm able to accomplish that very, very easily. So simply put, the create table and the alter table and the number of options that are in there are very involved. I just wanted to show you some of the pieces of that.
