Mysql Alter Allow Null
Mysql Alter Allow Null is used to change the Null Type
of a column in a table.The Allow Null allows the null type
characteristics in a column of the table. The Null Type column can be leave
empty.
Understand with Example
The section of Tutorial illustrate an example from 'Mysql Alter Allow
Null'.To understand this example we create a table 'usertable' with required
fieldname and datatype respectively.
Create table 'usertable':
CREATE TABLE `usertable` (
`username` varchar(200) NOT NULL,
`first_name` varchar(200) NOT NULL,
`last_name` varchar(200) NOT NULL
) |
Query to insert records or rows to the table 'usertable':
The insert into is used to add the records or rows to the table 'usertable'.
insert into usertable values('vin','Vineet','Bansal');
insert into usertable values(' srbh','Sourabh','Ranjan');
insert into usertable values(' amit','Amit','Kumar');
insert into usertable values('sandeep','Sandeep','Kumar'); |
Query to view the details of 'usertable':
The Select Query helps you to return the detail from table 'usertable'.
+----------+------------+-----------+
| username | first_name | last_name |
+----------+------------+-----------+
| vin | Vineet | Bansal |
| srbh | Sourabh | Ranjan |
| amit | Amit | Kumar |
| sandeep | Sandeep | Kumar | |
Alter Table "usertable" last_name allow NULL
The Alter Query is used to modify or change the 'usertable '
definition and modify keyword allows the null value to be 'YES' in the
table 'usertable'.
| ALTER table usertable Modify last_name varchar(50) null; |
Describe Table:
The Describe Table is used to describe the FieldType,Null,Key,etc of
table 'usertable'..
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| username | varchar(50) | NO | | | |
| first_name | varchar(200) | NO | | | |
| last_name | varchar(50) | YES | | | |
+------------+--------------+------+-----+---------+-------+ |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
