Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How To: Alter Table In MySQL (3 Min) | Modify Columns, Alter Foreign Key Contraints. That video is uploaded by Gokce DB at 2022-02-04T14:23:50-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [oaOdE7MIV7c]
| Name | How To: Alter Table In MySQL (3 Min) | Modify Columns, Alter Foreign Key Contraints |
| Video Uploader | Video From Gokce DB |
| Upload Date | This Video Uploaded At 04-02-2022 22:23:50 |
| Video Discription | In this tutorial, you'll learn how to alter table in MySQL, modify table columns, delete columns, alter foreign keys and more. — Facebook: https://www.facebook.com/GokceDBsql — Video Transcript: — Connect MySQL In Python: https://www.youtube.com/watch?v=0qBctY82et0 — Hi guys, this is Abhi from Gokcedb. In this video, you're going to learn how to use Alter Table in MySQL. Let’s start by creating these four tables' properties. Cache underscore sales, sales underscore status, and customer. Let's look at the create table SQL for the property table. Here, I'm using ID as my primary key to connect to the MySQL Database. I'm using a config file to pass in my authentication details. Next, let's input create table property SQL file to the MySQL alias. To check the table structure, use the desc or the describe keyword. I'm going to speed up the video and create the rest of the tables. Let’s say I want to alter the cash underscore sales table and modify the cash underscore sales underscore doc underscore fee column and change the data type to decimal 13 comma 2 and remove the not null constraint. To do that, I'm going to write alter table cash underscore sales modify cash underscore sales underscore doc underscore fee decimal 13 commas 2 in parentheses. To verify if the changes went through, use the describe or the desc keyword. Say you wanted to get rid of the doc fee column altogether that you would write alter table cash underscore sales drop column cash underscore sales underscore dock underscore fee. Use the described keyword to verify. To add the column back, type alter table cash underscore sales add column cash underscore sales underscore dock underscore fee decimal 10 commas 2 not null after cash underscore sales underscore price. Use the describe keyword to verify. Say you wanted to get information on the foreign key constraints on the cash underscore sales table. To do that, type show create table cash underscore sales. Next, if you wanted to get rid of the FK underscore cash underscore sales underscore property underscore id foreign key. Here's how you do it. Type alter table cash underscore sales drop foreign key then the name of the foreign key. To verify, use the show create table keyword. To add to the table you would type alter table, cache underscore sales at constraint name of the constraint, name of the constraint foreign key, property underscore ID, references, property id on delete cascade on update cascade. To verify your changes, use the show create table keyword. There you have it. Make you like, subscribe and turn on the notification bell. Until next time. oaOdE7MIV7c |
| Category | Education |
| Tags | alter table in MySQL | modify table columns | delete columns | alter foreign keys | alter table | sql server | sql interview questions | drop column | mysql tutorial | sql for beginners | learn mysql | learning mysql | intro to mysql | foreign key in mysql | mysql for beginners with examples | sql developer | sql tutorial | mysql for beginners | foreign key in sql | learn sql for beginners | mysql tutorial for beginners | foreign key | learn sql in 1 hour | mysql for beginners tutorial |
