Tables Part 1 – Create, Drop, Show Status

/* Create Table With 3 Fields */
Create TABLE students (
  id int(11),
  name varchar(255),
  email varchar(255)
);

/* Show Columns Inside Table */

DESCRIBE students; # Shortcut For => SHOW COLUMNS FROM table_name;

DESC students; # Short For DESCRIBE

EXPLAIN students; # Same As Describe

SHOW COLUMNS FROM students; # Same As Previous Results

SHOW FIELDS FROM students; # Same As Previous Results

/* Show The Status Of The Tables */

SHOW TABLE STATUS;