CREATE TABLE

Description

Create a new table.

Syntax

1. > CREATE TABLE [IF NOT EXISTS] [db.]table_name
2. (
3. name1 type1,
4. name2 type2,
5. ...
6. )

create_table_statement:

Create Table Diagram

Examples

1. > CREATE TABLE test(a int, b varchar(10));

3. > INSERT INTO test values(123, 'abc');

5. > SELECT * FROM test;
6. +------+---------+
7. |   a  |    b    |
8. +------+---------+
9. |  123 |   abc   |
10. +------+---------+