: Create Table : Table MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Table
»
Create Table
»
36.1 .
The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set
Hits: 1100
36.2 .
Table and Column Definition with character and collate
Hits: 1243
36.3 .
Creating a Table with an Index
Hits: 1201
36.4 .
Creating table with Foreign key
Hits: 1307
36.5 .
Create a table by UNION another table
Hits: 1274
36.6 .
Copy a table with Create ... Select statement
Hits: 1269
36.7 .
TYPE=MYISAM
Hits: 1386
36.8 .
CREATE TABLE table_name (column_name field_type [NULL|NOT NULL],KEY col_index(column_name));
Hits: 1247
36.9 .
'IF NOT EXISTS' parameter can be used to check if a table exists before you actually create it
Hits: 1235
36.10 .
Use a CREATE TABLE statement to specify the layout of your table
Hits: 1235
36.11 .
Creating Tables with AUTO_INCREMENT and NOT NULL column
Hits: 1347
36.12 .
The syntax for creating a table
Hits: 1198
MySQL TUTORIALS
Table
»
Create Table
Create Table
Column Modifiers
Describe Table Structure
Drop Column
Alter Table
Default
Copy Table
Key
Rename Table
PRIMARY KEY
TRUNCATE TABLE
Foreign Keys
Drop Table
Unique
Temporary Table
AUTO_INCREMENT
Add Column
Index
Alter Column
COLLATION Character Set
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set
