DDL

Adatbázis létrehozása

CREATE DATABASE [IF NOT EXISTS] database_name
  [CHARACTER SET charset_name]
  [COLLATE collation_name];

Tábla létrehozása

CREATE TABLE [IF NOT EXISTS]
table_name(

column_1_definition*,
column_2_definition*,
...
table_constraints
);

*column’s definition: column_name data_type(length) [NOT NULL] [DEFAULT value] [AUTO_INCREMENT] column_constraint

Rekordok beszúrása

INSERT INTO table(column1, column2, ...) 

VALUES 

(value1, value2, ...), 
(value1, value2, ...), 
...
(value1, value2, ...);

Feladatlapok