Column Modifiers : Column Modifiers « Table « MySQL Tutorial

Home
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
MySQL Tutorial » Table » Column Modifiers 
4.11.1.Column Modifiers
Modifier NameApplicable Types
AUTO_INCREMENTAll INT Types
BINARYCHAR, VARCHAR
DEFAULTAll, except BLOB, TEXT
NOT NULLAll Types
NULLAll Types
PRIMARY KEYAll Types
UNIQUEAll Types
UNSIGNEDNumeric Types
ZEROFILLNumeric Types


The BINARY modifier causes the values to treated as binary strings, making them case sensitive.

The DEFAULT modifier specifies the default value.

The MySQL default value is NULL for all types except ENUM.

For ENUM, MySQL uses the first value of the enumerated list as the default.

For SET types, MySQL uses the empty string for the default.

To specify a DEFAULT value, use the following syntax:

mysql>
mysql> CREATE TABLE Test(State char(2NOT NULL DEFAULT "KY");
Query OK, rows affected (0.02 sec)

mysql>
mysql> insert into Test (statevalue (default);
Query OK, row affected (0.02 sec)

mysql>
mysql> select from Test;
+-------+
| State |
+-------+
| KY    |
+-------+
row in set (0.00 sec)

mysql>
mysql> drop table Test;
Query OK, rows affected (0.01 sec)

mysql>
mysql>

The NULL and NOT NULL modifiers specify nullable column.

The PRIMARY KEY is actually an index that must contain unique values.

The UNIQUE modifier enforces that all data within the declared column must be unique.

4.11.Column Modifiers
4.11.1.Column Modifiers
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.