Name: MySQL - レコードの更新と削除 (更新、削除) (MySQL - Update and Delete Records (update, delete))
Uploaded: 2021-01-14T10:27:04.000Z
Duration: 26 min 11 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

creating these classes requires equipment and service.

If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

He lied to Computer Guy, and in today's class, I'm going to be showing you how to up today and delete records within tables within your my sequel database.

So at this point, you should know how to be create databases.

You should know how to in a certain records into tables and how to use the select statement to be about pole records out of tables.

So at this point, we're going to show you how to basically modify those records.

So in the previous examples, and basically I put a number of kids as records into the user's table that we created.

And so when the questions is, what happens if one of those kids get older?

You know, they went for me nine years old, and now they're 10 years old, so you need to go in there and you'd actually be able to modify that record So that is what I'm going to show you today.

It is basically using what is called the update commands.

You'll be able to update records within your tables within my Siegel.

Then, of course, you know what happens if a user leaves, or for whatever reason, you want to delete a record within your my sequel table, I will be showing you how to use the police statement in order to do that.

And so that is what we're going to be learning today.

So now that we're ready to learn how to be ableto update records and delete records within your my sequel database tables, let's go over to the computer so I can show you how this works.

So here we are, back at my lab environment again, I'm running a Mac book professional using virtual box within virtual box.

I have spun up an instance of a bunch of desktop 18.0 force that's going to give us a graphical user environment, and this is what I have installed my sequel onto.

So if you have my sequel installing on Tween normal machine, that should work fine for you.

You go down here to show applications, then we're gonna type in terminal because we need to get that command prompt when you the terminal.

And now we are in the terminal session so we can actually get into my sequel.

Now, if your brand new to this series of classes you have not watched the previous series of classes.

I don't log in to my sequel the normal way.

So the normal way of logging into my sequel is my sequel Space Life in You User name Space Hyphen piece.

So this is the normal way that you will be along in N to you're my secret database server.

We have not created user accounts yet dealt with privileges and all that.

I'm kind of teaching some way, some would say and have an ass backwards way, But I think it's an ass front.

The way that I'm doing it right now is to do my sequel.

There are no do do pseudo pseudo my sequel.

So what this will do Is this Well, actually a log us in as the root a local host account, eh?

So this gives us all the full privileges on this particular database server.

If you already have a normal user account on, you're my secret database server with the appropriate privileges.

I'm just doing it this way because that's how this particular series of classes is going.

123456 on You Hit Return and you were in my sequel.

Uh, so I thought I talked about the previous class that whenever you're doing thes these little labs that you should try to recreate your database, recreate your table's recreate your rose or your records for every class to get you used to actually doing that.

I'm not going to do that today for this class because I don't want to waste the time.

I'm simply going to be using the database and the table that we already created in the previous class so we could go here so show that base is a semi colon and we could go take a look at our databases.

The one that we're gonna be using here is class the D B.

That's not be our database we're gonna go use, uh, Class B.

Now we have changed into the class d be allowed to control l to clear the screen.

And then just to make sure that we are in the right database, will d'oh select that a base, this command open brothers, he's close parentheses, semi colon enter.

And so this just shows us that we are, in fact, in the correct data base.

Remember, in the my secret world, they don't give you warnings.

They don't ask you if you want to do something, you type a command, and it does the command.

So if you're in the wrong database, you can get bad really quick.

So always, always verify you're in the right past that.

Then what we're gonna do is going to show the tables to see what tables we have in here.

DSC users could get an idea of what the user's table looks like.

So for the user's table, we've got to use your idea.

I d is an entity air and it is an auto increments.

That is our primary key name is text Ade is entered.

One of the things that's very important is if you're going to be updating records to know what data types you can use to be able to update.

Is it afloat and again, like with interviewers?

Those air enters floats or decimals would be 10.25.

So if you have a decimal point, that would be a float.

So this is important, something very be thinking about.

Like if you have something like a JJ, if you try to type in, you know, 11 dot that 11.0.5 for an age, you might run into some problems.

So you do need to make sure you know what data types are dealing with here.

And then finally, just to get an idea of what the dad looks like with our database, would you select all from users?

So this is select all columns from users and we don't have anything else.

Here s oh, it's going to take all the records and then we're going to hit inner and so we can see the user I d.

So number one is Bob, ages nine under his boy, Sue is he's ready to age 15.

Fred, this is righty 388 Gender boy on this is kind of interesting.

Just kind of see show you how this works.

So before I did the Chris class, I do a little Testing has make sure writing out all the statements properly.

And so I was the leading and adding some records.

And so one of the interesting things just to realize with this whole auto increments or user i d auto increments.

Every time a new record is created, it ticks up one place.

Even though Pat is in the fourth position, the user i d is six because we've actually this point created six user ideas.

I've simply deleted a couple of them because I don't need them anymore.

But it is just kind of interesting to look at that from the auto increment standpoint to realize that Pat is not user.

I d four is actually user i d six and again when you're doing things like circuit is when you're doing things like updates, keeping that in mind could be could be important again.

Just because they're in the fourth position doesn't mean that's what, like their user i d or the part I d or whatever ISS s.

字幕リスト動画再生

MySQL - レコードの更新と削除 (更新、削除) (MySQL - Update and Delete Records (update, delete))

multiple

basically

concept

elite