Friday, February 7, 2020

Warnings

MySQL Warnings Code

DESC cats; 
Try Inserting a cat with a super long name:
Then view the warning:
SHOW WARNINGS; 
Try inserting a cat with incorrect data types:
INSERT INTO cats(name, age) VALUES('Lima', 'dsfasdfdas'); 
Then view the warning:
SHOW WARNINGS; 

No comments:

Post a Comment

Right Joins

-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders     ON customers.id = orders.custom...