Home Sql Mysql-alter Mysql Alter Add Column
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Mysql Alter Add Column

Advertisement
Mysql Alter Add Column is used to define the existing Table and add a new column to it.

Mysql Alter Add Column

     

Mysql Alter Add Column is used to define the existing Table and add a new column to it.

Understand with Example

The Tutorial demonstrate you 'Mysql Alter Add Column'. To understand this example, we create a table employees using create table statement in Mysql. The table employees has a 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 into 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 'employees' we use select query that return you the details.

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)

Query to alter Table named employees by adding column named city:

The Query Alter is used to define the table 'employees' and add a new column 'city' to the existing table 'employees'.

mysql> alter table employees
    -> add column city varchar(30);
Query OK, 2 rows affected (0.13 sec)
Records: 2  Duplicates: 0  Warnings: 0

Output:-

mysql> select * from employees;
+-------+---------+------------+------+
| Empid | Empname | date       | city |
+-------+---------+------------+------+
|     1 | Girish  | 2008-12-22 | NULL |
|     2 | Komal   | 2008-12-23 | NULL |
+-------+---------+------------+------+
2 rows in set (0.02 sec)
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 13, 2009

Ask Questions?    Discuss: Mysql Alter Add Column  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
leela
May 13, 2012
delete a

I created a table in mysql containing 2 columns ,userid,movieid.I entered the values in movieid column using arraylist. the table contains the following data userid movieid 1 12234,5688,8976 2 567 now i want to delete 12234 in movieid column where userid=1 how i can write the query in mysql.can anyone help me.
DMCA.com