Creating a Table : Create Table « Table Index « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » Table Index » Create Table

Creating a Table

        

mysql>

mysql>

mysql> CREATE TABLE sales_rep(

    ->   employee_number INT,

    ->   surname VARCHAR(40),

    ->   first_name VARCHAR(30),

    ->   commission TINYINT

    -> );

Query OK, 0 rows affected (0.00 sec)



mysql>

mysql> drop table sales_rep;

Query OK, 0 rows affected (0.00 sec)



mysql>

Related examples in the same category

1.	Create Simple Tables
2.	Create table: default value for column
3.	Create table: small int and unsigned int
4.	Create table: smallint, decimal and float
5.	Create table: char, varchar
6.	Create table: BLOB
7.	Create table: char set and language
8.	Create table: ENUM and set
9.	Create table: YEAR and TIMESTAMP
10.	Create table: null and not null
11.	Create table: not null and default value
12.	Create table: default int value
13.	Create table: primary key
14.	Create table: primary key 2
15.	Create table: two columns for primary key
16.	Create table: auto increment primary key
17.	Create table: REFERENCES
18.	Create table: foreign key
19.	Create table: engine type INNODB
20.	Set average row length and max, min rows
21.	Syntax for Creating Tables (CREATE TABLE)
22.	Create an empty table, use a WHERE clause that is always false
23.	To produce a summary that includes all hours of the day, create a reference table that lists each hour
24.	Creates table-level privileges.
25.	Create a copy of the product table:
26.	Create a table called cust_names using the table definitions and data from the product table.
27.	CREATE TABLE IF NOT EXISTS
28.	CREATE TABLE TEAMS_COPY1 LIKE TEAMS
29.	Creating Copies of a Table
30.	Creating a New Table by Copying
31.	Add an IF NOT EXISTS clause to the statement:

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.