How to RENAME, COPY, EDIT & MODIFY DATABASES, ADD & DROP FOREIGN KEY, CONSTRAINTS in MySQL Workbench

​@MattMacarty
#MySQL #Workbench #Database
How to edit MySQL database tables
✅ Please SUBSCRIBE:
ruclips.net/user/subscription_...
✅ 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... )

[@henrytzuo8517]

Thank you so much!! Very clear!!🙂🙂🙂

[@MattMacarty]

Glad it helped

[@simonoganga5956]

You are a rock star of SQL. Amazing job

[@MattMacarty]

Thank you. Glad it helped

[@monavdyli6327]

Thank you very much
I really like your strategy of explaining things. Straight to the point, this does this, and that does that.
Thank you again, please make more videos like this

[@MattMacarty]

Thank you. Glad it helped

[@Ritu-TheWinner]

Thank you Sir!

[@MattMacarty]

Glad it helped

[@retrofrost9433]

Thank you very much ,Sir.

[@MattMacarty]

Glad it helped

[@moondevonyt]

thank you for the video. do you have a github?

[@MattMacarty]

Hi, yes: github.com/mjmacarty/mysql