MySQL: DEFAULT constraint is easy

[@BroCodez]

- EXAMPLE 1 CREATE TABLE products ( product_id INT, product_name varchar(25), price DECIMAL(4, 2) DEFAULT 0 ); ALTER TABLE products ALTER price SET DEFAULT 0; INSERT INTO products (product_id, product_name) VALUES (104, "straw"), (105, "napkin"), (106, "fork"), (107, "spoon"); SELECT * FROM products; - EXAMPLE 2 CREATE TABLE transactions( transaction_id INT, amount DECIMAL(5, 2), transaction_date DATETIME DEFAULT NOW() ); SELECT * FROM transactions; INSERT INTO transactions (transaction_id, amount) VALUES (1, 4.99); SELECT * FROM transactions; INSERT INTO transactions (transaction_id, amount) VALUES (2, 2.89); SELECT * FROM transactions; INSERT INTO transactions (transaction_id, amount) VALUES (3, 8.37); SELECT * FROM transactions; DROP TABLE transactions;

[@vaishnutejass2724]

very easy to understand thanku

[@UNFOLDTECH]

yeah

[@bichoron3603]

Great!! Please keep uploading videos of sql more & more

[@timon1816]

Dude, I was just thinking about trying Mysql today and you're releasing this video. Thank you very much!

[@GldnClaw]

2:24 looks like you answered my question from a few videos ago.

[@AishaSalat-k8i]

i just see myself graduating because of your page bro,thank you so much

[@sweethomes674]

Thank you-excellent 🕊

[@MISA-qy4hx]

Why did you use ALTER instead of MODIFY? 03:40

[@dixsonjoy5394]

I also have this doubt

[@apoorvsxna]

This would also work- ALTER TABLE products MODIFY price DECIMAL (5,2) DEFAULT 0.00;

[@bartsworkshop]

Thank you for making these videos, they are easy to follow and understand.

[@mitishacolbert277]

You are the best

[@imanelmzk2064]

you're a Legend, thank you so much!!, that's so helpful!!!!

[@omarhashem6358]

Please continue the series❤

[@Crazy_moments_of_footbal-qz1qr]

you great!!!!!!

[@techboomers8935]

Kindly kindly Bro share us your Programming life journey or Q/A OR you interview and face revealed, love from Pakistan

[@mohaymenul-islam]

✅

[@nirajchaudhary1621]

👀