Databases| SQL| MySQL| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials

Latest Questions
Comments
 
Mysql Alter Column Size 
 

Mysql Alter Column Size is used to change the data size of a column in a table.

 

Mysql Alter Column Size

                         

Mysql Alter Column Size is used to change the data size of a column in a table.

Understand with Example

The Tutorial illustrate an example from 'Mysql Alter Column Size'. To understand example we create table 'employees' that include empid as primary key.

 

 

 

 

Query to create table:-

CREATE TABLE `employees` (
            ->Empid int(10),  
            ->Empname varchar(60),
             ->date date
            ->PRIMARY KEY(empid)  
           ->);

Query to insert data into Table named employees:

The insert into add the records or rows to the table 'employees'.

mysql>insert into employees values(01,'Girish','2008-12-22');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-23');
Query OK, 1 row affected (0.02 sec)

Query to view data of  Table named employees:

To view the detail  from table 'employee' we use select Query that return the records from table 'employees'. 

mysql> select * from employees;

Output:

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     1 | Girish  | 2008-12-22 |
|     2 | Komal   | 2008-12-23 |
+-------+---------+------------+
2 rows in set (0.00 sec)

Data type of Table named employees before altering column size:

The Query below define the table field ,data type,Null ,key ,default  etc properties.

+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| empid   | int(11)     | NO   | PRI | NULL    | auto_increment |
| Empname | varchar(60) | NO   |     |         |                |
| date    | date        | YES  |     | NULL    |                |
+---------+-------------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

Query to alter column size of the Table named employees:

The Query Alter is used to modify the definition of table 'employees' and change the size of column datatype.

mysql> alter table employees
    -> change empname empname varchar(130);
Query OK, 2 rows affected (0.13 sec)
Records: 2  Duplicates: 0  Warnings: 0

Data type of Table named employees after altering column size:-

mysql> describe employees;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| empid   | int(11)      | NO   | PRI | NULL    | auto_increment |
| empname | varchar(130) | YES  |     | NULL    |                |
| date    | date         | YES  |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
3 rows in set (0.03 sec)

                         

» View all related tutorials
Related Tags: sql mysql c table io multiple sed column ip definition name columns rename tab if to ini modify e it

Leave your comment:

Name:

Email:

URL:

Title:

Comments:


Enter Code:

Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Software Solutions
Least Viewed
Most Rated
Recently Viewed
Search Tutorials

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.