The syntax for creating a table : Create Table « Table « MySQL Tutorial

MySQL Tutorial

1.	Introduction
2.	Select Query
3.	Database
4.	Table
5.	Table Join
6.	Subquery
7.	Insert Update Delete
8.	Logic Operator
9.	View
10.	Data Types
11.	Procedure Function
12.	Cursor
13.	Trigger
14.	Date Time Functions
15.	Comparison Functions Operators
16.	Aggregate Functions
17.	Cast Functions Operators
18.	Control Flow Functions
19.	Encryption Compression Functions
20.	Information Functions
21.	Math Numeric Functions
22.	Miscellaneous Functions
23.	String Functions
24.	Regular Expressions
25.	Data Dictionary
26.	MySQL Utilities
27.	Privilege

Java

Java Tutorial

Java Source Code / Java Documentation

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

MySQL Tutorial » Table » Create Table

4. 1. 1. The syntax for creating a table

The syntax for creating a table is as follows:


CREATE TABLE <table_name> (

       field1 datatype,

       field2 datatype,

       etc......

);

When splitting over multiple lines within the MySQL command line the continuation indictor(->) will be used.


mysql> CREATE TABLE <table_name> (

    -> field1 datatype,

    -> field2 datatype,

    -> etc......);

The command statement will not be executed until you use a semi-colon.


mysql>

mysql> CREATE TABLE employee (

    ->     ID INT(2) auto_increment primary key,

    ->     First_name VARCHAR(20),

    ->     Last_name VARCHAR(30),

    ->     Start_date DATE,

    ->     Salary int(6),

    ->     city VARCHAR(20),

    ->     description VARCHAR(20)

    -> );

Query OK, 0 rows affected (0.03 sec)



mysql>

mysql> desc employee;

+-------------+-------------+------+-----+---------+----------------+

| Field       | Type        | Null | Key | Default | Extra          |

+-------------+-------------+------+-----+---------+----------------+

| ID          | int(2)      | NO   | PRI | NULL    | auto_increment |

| First_name  | varchar(20) | YES  |     | NULL    |                |

| Last_name   | varchar(30) | YES  |     | NULL    |                |

| Start_date  | date        | YES  |     | NULL    |                |

| Salary      | int(6)      | YES  |     | NULL    |                |

| city        | varchar(20) | YES  |     | NULL    |                |

| description | varchar(20) | YES  |     | NULL    |                |

+-------------+-------------+------+-----+---------+----------------+

7 rows in set (0.05 sec)



mysql>

mysql> drop table employee;

Query OK, 0 rows affected (0.00 sec)



mysql>

4. 1. Create Table
	4. 1. 1.	The syntax for creating a table
	4. 1. 2.	Creating Tables with AUTO_INCREMENT and NOT NULL column
	4. 1. 3.	Use a CREATE TABLE statement to specify the layout of your table:
	4. 1. 4.	'IF NOT EXISTS' parameter can be used to check if a table exists before you actually create it
	4. 1. 5.	CREATE TABLE table_name (column_name field_type [NULL\|NOT NULL],KEY col_index(column_name));
	4. 1. 6.	TYPE=MYISAM
	4. 1. 7.	Copy a table with Create ... Select statement
	4. 1. 8.	Create a table by UNION another table
	4. 1. 9.	Creating table with Foreign key
	4. 1. 10.	Creating a Table with an Index
	4. 1. 11.	Table and Column Definition with character and collate
	4. 1. 12.	The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.