The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set : Create Table « Table « MySQL Tutorial






  1. MySQL Tutorial
  2. Table
  3. Create Table

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