​‪@MattMacarty‬
#MySQL #Workbench #Database
How to edit MySQL database tables
✅ Please SUBSCRIBE:
kzread.info_...
✅ Get the code at:
github.com/mjmacarty/mysql
✅ Topics include:
0:00 Introduction
0:48 Rename a table
1:50 Copy Table Structure
2:44 Copy a Table
3:23 Rename a Column
4:15 Change Data Type
5:35 Add a Column
6:30 Data Validation (Constraints)
9:00 Remove Constraint
10:20 Show Create Table
12:00 Set Default Value
14:30 Enum Data Type
16:20 Delete a Primary Key
15:58 Delete a Column
17:35 Delete a Table
You may also be interested in:
1. [Creating Databases and Tables]( • How to Create a Databa... )
2. [Basic Query Operation]( • Introduction to Querie... )
3. [Add Foreign Keys]( • How Add a Foreign Key ... )
4. [INNER and OUTER JOINS]( • Introduction to INNER ... )
5. [Introductory Subqueries]( • Introduction to Subque... )
6. [If and CASE WHEN THEN]( • How to Use IF and CASE... )
7. [Text Functions]( • Using Text Functions/ ... )
8. [Statistical Functions]( • MySQL Statistics and M... )
9. [How to Make an EER Diagram]( • How to Make and Use an... )