Lessons:16Length:1.5 hours
4.3 Creating Many-to-Many Tables
Let's stretch the concept of table relationships. In this lesson, you are going to learn how to construct a table relationship know as the "Many-to-Many" relationship. In this scenario, many instances of one table can reference many instances of another table. It might sound complicated, but it truly is fairly simple with some basic concepts.
Related Links
1.Introduction
1.1Introduction00:40
1.1
Introduction
00:40
1.2Prerequisites07:25
1.2
Prerequisites
07:25
1.3General MySQL Commands05:46
1.3
General MySQL Commands
05:46
2.Working With MySQL Databases and Tables
2.1Creating and Deleting Databases02:06
2.1
Creating and Deleting Databases
02:06
2.2Creating and Deleting Tables07:10
2.2
Creating and Deleting Tables
07:10
2.3Creating Tables With Additional Options06:56
2.3
Creating Tables With Additional Options
06:56
3.Basic Database Read and Write Operations
3.1Inserting Data Into Tables04:59
3.1
Inserting Data Into Tables
04:59
3.2Select Query Basics05:48
3.2
Select Query Basics
05:48
3.3Update Query Basics05:40
3.3
Update Query Basics
05:40
3.4Delete Query Basics03:46
3.4
Delete Query Basics
03:46
3.5Modifying Table Structures07:58
3.5
Modifying Table Structures
07:58
4.Relationships Between Tables
4.1Creating One-to-Many Tables06:29
4.1
Creating One-to-Many Tables
06:29
4.2Joining Tables Together07:20
4.2
Joining Tables Together
07:20
4.3Creating Many-to-Many Tables07:54
4.3
Creating Many-to-Many Tables
07:54
4.4Joining Many Tables Together06:34
4.4
Joining Many Tables Together
06:34
5.Conclusion
5.1Conclusion02:50
5.1
Conclusion
02:50
