QUERY (Sintak) MYSQL

_nNajmiEe_


·         CREATE DATABASE db_name
·         DROP DATABASE [IF EXISTS] db_name
·         CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,…)] [ table_options] [select_statement]
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition]
       or    PRIMARY KEY (index_col_name,...)
       or    KEY [index_name] (index_col_name,...)
       or    INDEX [index_name] (index_col_name,...)
       or    UNIQUE [INDEX] [index_name] (index_col_name,...)
       or    [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)
                 [reference_definition]
       or    CHECK (expr)

type:
             TINYINT[(length)] [UNSIGNED] [ZEROFILL]
       or    SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
       or    MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
       or    INT[(length)] [UNSIGNED] [ZEROFILL]
       or    INTEGER[(length)] [UNSIGNED] [ZEROFILL]
       or    BIGINT[(length)] [UNSIGNED] [ZEROFILL]
       or    REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
       or    DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
       or    FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
       or    DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
       or    NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
       or    CHAR(length) [BINARY]
       or    VARCHAR(length) [BINARY]
       or    DATE
       or    TIME
       or    TIMESTAMP
       or    DATETIME
       or    TINYBLOB
       or    BLOB
       or    MEDIUMBLOB
       or    LONGBLOB
       or    TINYTEXT
       or    TEXT
       or    MEDIUMTEXT
       or    LONGTEXT
       or    ENUM(value1,value2,value3,...)
       or    SET(value1,value2,value3,...)

     index_col_name:
             col_name [(length)]

     reference_definition:
             REFERENCES tbl_name [(index_col_name,...)]
                        [MATCH FULL | MATCH PARTIAL]
                        [ON DELETE reference_option]
                        [ON UPDATE reference_option]

     reference_option:
             RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT

     table_options:
        TYPE = {ISAM | MYISAM | HEAP}
     or AUTO_INCREMENT = #
     or AVG_ROW_LENGTH = #
     or CHECKSUM = {0 | 1}
     or COMMENT = "string"
     or MAX_ROWS = #
     or MIN_ROWS = #
     or PACK_KEYS = {0 | 1}
     or PASSWORD = "string"
     or DELAY_KEY_WRITE = {0 | 1}
     or      ROW_FORMAT= { default | dynamic | static | compressed }

     select_statement:
        [IGNORE | REPLACE] SELECT ...  (Some legal select statement)

·         ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec … ]
alter_specification:
             ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
       or    ADD INDEX [index_name] (index_col_name,...)
       or    ADD PRIMARY KEY (index_col_name,...)
       or    ADD UNIQUE [index_name] (index_col_name,...)

0 komentar

Label:

0 komentar:

Posting Komentar