You explained in 5 minutes what my Argentinian teacher couldn't in one hour. My main language is Spanish and yet it was way clearer with you. Thank you!!!
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??
- 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);
You explained in 5 minutes what my Argentinian teacher couldn't in one hour. My main language is Spanish and yet it was way clearer with you. Thank you!!!
First, heart?Btw ur coding videos are the best, you help and educate so many 😁
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?
✅
John Smith Lol😂😂
Thank you for this video big bro.
Pls what is the difference between the primary key and the unique constraint?
unique constraint could be null
Also when using primary key, the data is inserted into the table as sorted, based on the value of the primary key column.
why does my sql table add a null row after i added a PRIMARY KEY constraint?
Got the same question
Good Video , How to get Primary Key Auto Generated ? 🔑🔑
next video
Auto_increment
How do you make primary keys like "AA-0001"??
set the datatype to string
For whatever reason, I thought you were Canadian until now.
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??
true
make subtitles for portuguese br please😳😳😳
Damn, a hamburger and a soda for 4.99? That's cheap even here in Brazil lol