Databases| SQL| MySQL| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials

Latest Questions
Comments
 
Mysql Alter Multiple Columns 
 

Mysql Alter Multiple Columns is used to modify the table definition and rename the columns name in a table.

 

Mysql Alter Multiple Columns

                         

Mysql Alter Multiple Columns is used to modify the table definition and rename the columns name in a table.

Understand with Example

The Tutorial illustrate an example from 'Mysql Alter Multiple Columns'. To grasp this example we create a table employee1.The create table is  used to create a table employee1 with respective fieldname and datatype.

Query to Create Table named employee1:

mysql>CREATE TABLE employee1 (              
         ->    Empid int(10),         
         ->    Empname varchar(60),   
         ->    date date 
         ->  );

Query to insert data into Table named employee1:

To insert the records or value into table employee1, we use insert into query that add records or rows into table employee1.

mysql>insert into employee1 values(01,'Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)

mysql>insert into employee1 values(02,'Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)

mysql>insert into employee1 values(03,'vineet','2008-12-21');
Query OK, 1 row affected (0.02 sec)

mysql>insert into employee1 values(04,'Amit','2008-12-20');
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)

mysql>insert into employee1 values(02,'Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)

mysql>insert into employee1 values(02,'suman','2008-12-25');
Query OK, 1 row affected (0.02 sec)

mysql>insert into employee1 values(01,'AAA',' 2008-12-03');
Query OK, 1 row affected (0.02 sec)

Query to view data of  Table named employee1:

To view the detail of table employee1, we use select query that returns you the detail of table employee1.

mysql> select * from employee1;

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     1 | Girish  | 2008-12-20 |
|     2 | Komal   | 2008-12-21 |
|     3 | vineet  | 2008-12-21 |
|     4 | Amit    | 2008-12-20 |
|     2 | Komal   | 2008-12-23 |
|     2 | Sandeep | 2008-12-24 |
|     2 | suman   | 2008-12-25 |
|     1 | AAA     | 2008-12-03 |
+-------+---------+------------+
8 rows in set (0.00 sec)

Query to alter multiple column's of  Table named employee1:

The Query alter modifies the table employee1 and change the existing column name. The change keyword allows you to rename the existing column name in table employee1..

mysql> alter table employee1
    ->  change Empname Name varchar(100),
    ->   change Dateofbirth DOB date;

Output:-

mysql> select * from employee1;
+-------+---------+------------+
| Empid | Name    | DOB        |
+-------+---------+------------+
| 1     | Girish  | 2008-12-20 |
| 2     | Komal   | 2008-12-21 |
| 3     | vineet  | 2008-12-21 |
| 4     | Amit    | 2008-12-20 |
| 2     | Komal   | 2008-12-23 |
| 2     | Sandeep | 2008-12-24 |
| 2     | suman   | 2008-12-25 |
| 1     | AAA     | 2008-12-03 |
+-------+---------+------------+
8 rows in set (0.00 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.