- CREATE TABLE tablename
- (
- column_name data_type,
- column_name data_type
- );
- CREATE TABLE cats
- (
- name VARCHAR(100),
- age INT
- );
Seeing tables:
SHOW TABLES;
SHOW COLUMS FROM <tablename>;
DESC <tablename>;
-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders ON customers.id = orders.custom...
No comments:
Post a Comment