filmov
tv
Learning MySQL - FOREIGN KEY CONSTRAINTS
Показать описание
This tutorial covers what Foreign Keys are, what Constraints are, how to create foreign keys, constraints and how to implement actions based on the constraints.
MySQL Playlist:
MySQL Foreign Key Constraint Reference:
CODE SAMPLE:
ALTER TABLE characters DROP FOREIGN KEY `fk_character_race`;
DROP TABLE IF EXISTS races;
DROP TABLE IF EXISTS characters;
CREATE TABLE races (
race_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
race_name VARCHAR(30) NOT NULL
)ENGINE=INNODB;
CREATE TABLE characters(
character_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY Key,
character_name VARCHAR(50) NOT NULL,
race_id TINYINT UNSIGNED NOT NULL,
INDEX `idx_race`(race_id),
CONSTRAINT `fk_character_race`
FOREIGN KEY (race_id)
REFERENCES races(race_id) ON UPDATE CASCADE ON DELETE RESTRICT
)ENGINE=INNODB;
MySQL Playlist:
MySQL Foreign Key Constraint Reference:
CODE SAMPLE:
ALTER TABLE characters DROP FOREIGN KEY `fk_character_race`;
DROP TABLE IF EXISTS races;
DROP TABLE IF EXISTS characters;
CREATE TABLE races (
race_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
race_name VARCHAR(30) NOT NULL
)ENGINE=INNODB;
CREATE TABLE characters(
character_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY Key,
character_name VARCHAR(50) NOT NULL,
race_id TINYINT UNSIGNED NOT NULL,
INDEX `idx_race`(race_id),
CONSTRAINT `fk_character_race`
FOREIGN KEY (race_id)
REFERENCES races(race_id) ON UPDATE CASCADE ON DELETE RESTRICT
)ENGINE=INNODB;
0:08:17
MySQL: FOREIGN KEYS are easy (kind of)
0:11:52
Learning MySQL - FOREIGN KEY CONSTRAINTS
0:08:40
Primary Key and Foreign Key Tutorial in MySQL | What is Primary Key and Foreign Key DBMS | Edureka
0:08:25
Primary & Foreign Keys
0:05:58
How to create foreign key in phpMyAdmin
0:25:43
MySQL in 25 Minutes | Primary and Foreign Keys | Database Terminology for Beginners
0:10:48
How Add a Foreign Key Constraint (Make Relationships) in MySQL WorkBench
0:17:17
MySQL - The Basics // Learn SQL in 23 Easy Steps
0:49:28
Everything you need to know to design databases and use with ANY language.
0:04:25
SQL Server 27 - How to Create FOREIGN KEY Constraints
0:10:24
MySQL tutorial 18 - Foreign Keys
0:06:13
Primary Key & Foreign Key Implementation: MySQL
0:09:51
SQL Server Tutorial - One-to-many and many-to-many table relationships
0:13:11
Learn MySQL In Arabic #16 - Constraint - Foreign Key Intro
0:07:31
MySQL: ON DELETE
0:09:50
MySQL Tutorial for Beginners 30 - MySQL FOREIGN KEY Constraint
0:07:49
MySQL Tutorial: Auto_increment, Primary key, Foreign key | Hands on Tutorial | TechGeekyArti
3:00:00
MySQL Full Course for free 🐬 (2023)
0:06:36
Add Foreign key constraint to existing column in Mysql tutorial
0:16:12
MySql 5 | Primary Key and Foreign Key in MySQL Explained with Examples
0:24:25
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
0:02:23
SQL Explained in 100 Seconds
0:02:52
Foreign Key in MySQL with examples | Amit Thinks
0:05:04
MySQL: JOINS are easy (INNER, LEFT, RIGHT)
Комментарии