MySQL: PRIMARY KEYS are easy

Показать описание

#MySQL #tutorial #course

00:00:00 introduction
00:00:46 PRIMARY KEY with a new table
00:01:34 PRIMARY KEY with an existing table
00:02:11 examples
00:04:56 conclusion

– EXAMPLE 1 --

CREATE TABLE transactions (
transaction_id INT PRIMARY KEY,
amount DECIMAL(5, 2)
);

– EXAMPLE 2 --

ALTER TABLE transactions
ADD CONSTRAINT
PRIMARY KEY (transaction_id);

Рекомендации по теме

Комментарии

– EXAMPLE 1 --

CREATE TABLE transactions (
transaction_id INT PRIMARY KEY,
amount DECIMAL(5, 2)
);

– EXAMPLE 2 --

ALTER TABLE transactions
ADD CONSTRAINT
PRIMARY KEY (transaction_id);

BroCodez

First, heart?Btw ur coding videos are the best, you help and educate so many 😁

RGGBMGO

why does my sql table add a null row after i added a PRIMARY KEY constraint?

themachina

How do you make primary keys like "AA-0001"??

luistroyparaiso

create table transaction (
trans_id int,
amount decimal(10, 2),
constraint pk_transaction primary key(trans_id, amount)
); we apply primary key for multiple columns using this query... but in this video said, only one primary key for each table??

kusumaparimi

Thank you for this video big bro.

Pls what is the difference between the primary key and the unique constraint?

princeakinolaoluwagbemigag

For whatever reason, I thought you were Canadian until now.

crackrokmccaib

make subtitles for portuguese br please😳😳😳

emanuelitalo

Good Video, How to get Primary Key Auto Generated ? 🔑🔑

farhangmdc

MySQL: PRIMARY KEYS are easy

MySQL: PRIMARY KEYS are easy

MySQL: FOREIGN KEYS are easy (kind of)

Add PRIMARY KEY to existing column in sql | Mysql primary key constraint

Primary Key and Foreign Key Tutorial in MySQL | What is Primary Key and Foreign Key DBMS | Edureka

MySQL Tutorial for Beginners 28 - MySQL Primary Key

Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More

MySQL How To Choose the Primary Key

Primary & Foreign Keys

SQL Tutorial: Using Snowflake

#11 Understanding SQL Primary Key | SQL tutorial for beginners | in tamil

How to Create MySQL Primary Key

Primary key on two columns SQL Server

SQL PRIMARY KEY Constraint | SQL Server Tutorial for Beginners

Keys in RDBMS

SQL Server 26 - PRIMARY KEY, NOT NULL, UNIQUE

Primary Key Constraint in MySQL

Database Systems - Primary Keys - Creating Tables with a Primary Key in SQL

Remove or drop Primary Key constraint from existing column of a table in Mysql

Primary Key and Foreign Key in MySQL Explained with Examples | MySQL Tutorial

SQL:How to create PRIMARY KEY On Multiple Columns in New Table using Constraint Statement

Primary key and Surrogate key in DATABASE

4. Primary Key SQL MySQL Malayalam Tutorial

keys in SQL | DBMS Keys | Super keys | Candidate key | Primary key | Alternate key | Foreign key

DIFFERENCE BETWEEN SUPER KEY AND CANDIDATE KEY IN DBMS