How to insert values into a new column which is added into an existing table? Please answer me if you know how to insert values into a new column added into an existing table. Your answer will be highly appreciated
You need to update the existing table.

mysql&gt; create table tbl1(id int);
Query OK, 0 rows affected (0.04 sec)

mysql&gt; insert into tbl1 values(1);
Query OK, 1 row affected (0.00 sec)

mysql&gt; insert into tbl1 values(2);
Query OK, 1 row affected (0.00 sec)

mysql&gt; alter table tbl1 add column name varchar(20);
Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql&gt; select * from tbl1;
+------+------+
| id   | name |
+------+------+
|    1 | NULL |
|    2 | NULL |
+------+------+
2 rows in set (0.00 sec)

mysql&gt; update tbl1 set name='Jay' where id=1;
Query OK, 1 row affected (0.09 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql&gt; select * from tbl1;
+------+------+
| id   | name |
+------+------+
|    1 | Jay  |
|    2 | NULL |
+------+------+
2 rows in set (0.00 sec)

mysql&gt; update tbl1 set name='Joe' where id=2;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql&gt; select * from tbl1;
+------+------+
| id   | name |
+------+------+
|    1 | Jay  |
|    2 | Joe  |
+------+------+
2 rows in set (0.00 sec)