sql queries

Insert Query


mysql> insert into usertable values(1,'amit','pune',88888,'amit@gmail.com','chef');
Query OK, 1 row affected (0.07 sec)

mysql> select * from usertable;
+--------+------+---------+--------+----------------+----------+
| userid | user | Address | Mobile | Email          | Password |
+--------+------+---------+--------+----------------+----------+
|      1 | amit | pune    |  88888 | amit@gmail.com | chef     |
+--------+------+---------+--------+----------------+----------+
1 row in set (0.00 sec)




Update Query

mysql>update usertable set user='yanish' where userid=1;




mysql> select * from usertable;
+--------+--------+---------+--------+----------------+----------+
| userid | user   | Address | Mobile | Email          | Password |
+--------+--------+---------+--------+----------------+----------+
|      1 | yanish | pune    |  88888 | amit@gmail.com | chef     |
+--------+--------+---------+--------+----------------+----------+