This is Part 6 of the MySQL Beginner Tutorials series. In this video, we talk about performing different operations on table structure in MySQL. We discuss commands to view tables in a database and view structure for the tables. We then cover alter table command that includes add columns, add column constraints(like making a column primary key), modify column name, datatype or size, reorder columns, rename table name, rename column name and drop column. In the end, we talk about how to completely delete a table from a database using the drop command.
0:00 Introduction
0:49 ModifyingTable Structure
About me: I have been imparting computer education for more than 15 years to people of all age groups. I manage my own computer institute called Technical Education Center(TEC) and have also been a computer teacher for classes 6 to 12 in a CBSE affiliated school.