Create Table

iC Home > Know-how > MySQL Database > SQL > Create Table
MySQL Database	3.1 Create Table

← 3 SQL

[ up ] - [ A - Z ] - [ top ]

3.2 ALTER TABLE ... →

CREATE TABLE tsample
    (id INT,
    lastname VARCHAR(255),
    firstname VARCHAR(255),
    ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP
                  ON UPDATE CURRENT_TIMESTAMP,
    INDEX USING BTREE (id));

INSERT INTO tsample (id,lastname,firstname) values (1001,'Yankovic','Augusto');

CREATE TABLE t (
    ts1 TIMESTAMP DEFAULT 0,
    ts2 TIMESTAMP DEFAULT CURRENT_TIMESTAMP
                  ON UPDATE CURRENT_TIMESTAMP);

See also:

create table online
dev.mysql.com/doc/mysql/en/alter-table.html↑

<- 3 SQL 3.2 ALTER TABLE ... ->

copyright by reto - created with mytexi

MySQL Database

3.1 Create Table