Sentencias

A Very Fast Introduction to DL, DML & DCL
Faculty of Computer Science, BUAP Alejandra Apeleister, PhD
March, 2012

Data Definition Language (DDL)
• CREATE • DROP • ALTER User, Database, Table,Index

CREATE TABLE employees ( id INTEGER PRIMARY KEY, first_name CHAR(50) NULL, last_name CHAR(75) NOT NULL, dateofbirth DATE NULL );

DROP TABLE employees;

ALTER TABLE sink ADD bubblesINTEGER; ALTER TABLE sink DROP COLUMN bubbles;

Create Table Syntax
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(definition_create,...)] [options_table] [sentence_select] CREATE [TEMPORARY]TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)]; Definition_create columns_definition | [CONSTRAINT [symbol]] PRIMARY KEY (index_column_name,...) | KEY [index_name] (nombre_col_index,...) | INDEX[index_name] (index_col_name,...) | [CONSTRAINT [symbol]] UNIQUE [INDEX] [index_name] [index_type] (nombre_col_index,...) | [FULLTEXT|SPATIAL] [INDEX] [nombre_index] (nombre_col_index,...) |[CONSTRAINT [símbolo]] FOREIGN KEY [nombre_index] (nombre_col_index,...) [definición_referencia] | CHECK (expr) columns_definition column_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT][[PRIMARY] KEY] [COMMENT 'string'] [reference_definition] reference_definition REFERENCES table_name [(index_col_name,...)] [MATCH FULL | MATCH PARTIAL | MATCH SIMPLE] [ON DELETE reference_options] [ONUPDATE reference_options] reference_options RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT

MySQL column types
TINYINT[(length)] [UNSIGNED] [ZEROFILL] | SMALLINT[(length)] [UNSIGNED][ZEROFILL] | MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL] | INT[(length)] [UNSIGNED] [ZEROFILL] | INTEGER[(length)] [UNSIGNED] [ZEROFILL] | BIGINT[(length)] [UNSIGNED] [ZEROFILL] | REAL[(length,decimals)][UNSIGNED] [ZEROFILL] | DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL] | FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL] | DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL] | NUMERIC(length,decimals)...