Mysql Alter Add Column

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)

Advertisements

Ads
Share on Google+Share on Google+

Mysql Alter Add Column

Posted on: January 13, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Mysql Alter Add Column  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
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.

Ads

 

Ads