Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```mysql
- mysql> update users set fname="Surendra" where id=4;
- Query OK, 1 row affected (0.00 sec)
- Rows matched: 1 Changed: 1 Warnings: 0
- mysql> update users set fname="Darshan" where id=3;
- Query OK, 1 row affected (0.01 sec)
- Rows matched: 1 Changed: 1 Warnings: 0
- mysql> select * from users;
- +----+-----------+----------+----------+-------------------------------+--------------+
- | id | fname | lname | uname | email | contact |
- +----+-----------+----------+----------+-------------------------------+--------------+
- | 1 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
- | 2 | Sandeep | E | sandeep | sandeepeswar8@gmail.com | 919739040038 |
- | 3 | Darshan | Sidar | darshan | sidardarshan@gmail.com | 917996917565 |
- | 4 | Surendra | Prajapat | surendra | surendrakgadwal@gmail.com | 918385894407 |
- | 5 | Mukesh | Jakhar | mukesh | mjakhar.kjahhar@gmail.com | 919772254140 |
- | 6 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
- +----+-----------+----------+----------+-------------------------------+--------------+
- 6 rows in set (0.00 sec)
- mysql> delete from users where id=6;
- Query OK, 1 row affected (0.00 sec)
- mysql> select * from users;
- +----+-----------+----------+----------+-------------------------------+--------------+
- | id | fname | lname | uname | email | contact |
- +----+-----------+----------+----------+-------------------------------+--------------+
- | 1 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
- | 2 | Sandeep | E | sandeep | sandeepeswar8@gmail.com | 919739040038 |
- | 3 | Darshan | Sidar | darshan | sidardarshan@gmail.com | 917996917565 |
- | 4 | Surendra | Prajapat | surendra | surendrakgadwal@gmail.com | 918385894407 |
- | 5 | Mukesh | Jakhar | mukesh | mjakhar.kjahhar@gmail.com | 919772254140 |
- +----+-----------+----------+----------+-------------------------------+--------------+
- 5 rows in set (0.00 sec)
- mysql>
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement