sql

CREATING A TABLE

CREATE TABLE dogs (
   name VARCHAR(50),
   age INT
)

How do we know the row/columns affected ?

SHOW COLUMNS FROM <tablename>

(or)

DESC <tablename>

Drop tables

DROP TABLE <table-name>;

DROP TABLE cats;

Exercise - create table pastries

CREATE TABLE pastries ( name VARCHAR(50), quantity INT);