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);

[@BroCodez]

- 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);

[@RGGBMGO]

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

[@MissP3224]

Love the channel name!
I'm here to try and understand why the null values in the last row if I specify the Primary key?

[@MohammadMomin]

John Smith Lol😂😂

[@princeakinolaoluwagbemigag1750]

Thank you for this video big bro.
Pls what is the difference between the primary key and the unique constraint?

[@farisabufarha531]

unique constraint could be null

[@arihantgupta4480]

Also when using primary key, the data is inserted into the table as sorted, based on the value of the primary key column.

[@farhangmdc]

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

[@BroCodez]

next video

[@tarunmangalampalli1179]

Auto_increment

[@themachina7713]

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

[@martins__23]

Got the same question

[@luistroyparaiso5853]

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

[@peachezprogramming]

set the datatype to string

[@crackrokmccaib]

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

[@emanuelitalo5073]

make subtitles for portuguese br please😳😳😳

[@kusumaparimi2929]

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??

[@hertz-2007]

true