MySQL: What to Learn: SQL Statement Syntax

Briefly take a look at the topics as provided below. Then learn them one by one. Search google for each topic or use books, check the syntax, read about the topic, practice some examples, try to think about real-world programming tasks and how to apply the MySQL concepts.

Data Definition Statements

  • ALTER DATABASE
  • ALTER TABLE
  • CREATE DATABASE
  • CREATE INDEX
  • CREATE TABLE
  • DROP DATABASE