The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set : 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. 12. The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set

The ASCII attribute is shorthand for CHARACTER SET latin1.

The UNICODE attribute is shorthand for CHARACTER SET ucs2.

The BINARY attribute is shorthand for specifying the binary collation of the column character set.

The CHAR BYTE data type is an alias for the BINARY data type. This is a compatibility feature.


mysql>

mysql> CREATE TABLE myTable

    -> (

    ->     c1 VARCHAR(20) CHARACTER SET utf8,

    ->     c2 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs

    -> );

Query OK, 0 rows affected (0.06 sec)



mysql>

mysql>

mysql> drop table myTable;

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.