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

Опубликовано: 27 Апрель 2022
на канале: Matt Macarty

12,143

110

‪@MattMacarty‬
#MySQL #Workbench #Database
How to edit MySQL database tables

✅ Please SUBSCRIBE:
https://www.youtube.com/subscription_...

✅ Get the code at:
https://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](https://   • How to Create a Database, Add Tables ...  )
2. [Basic Query Operation](   • Introduction to Queries with MySQL Wo...  )
3. [Add Foreign Keys](   • How Add a Foreign Key Constraint (Mak...  )
4. [INNER and OUTER JOINS](   • Introduction to INNER and OUTER JOINS...  )
5. [Introductory Subqueries](   • Introduction to Subqueries with MySQL...  )
6. [If and CASE WHEN THEN](   • How to Use IF and CASE WHEN in MySQL ...  )
7. [Text Functions](   • Using Text Functions/ Manipulating Te...  )
8. [Statistical Functions](   • MySQL Statistics and Mathematical Fun...  )
9. [How to Make an EER Diagram](   • How to Make and Use an ERD/EER Diagra...  )