Advertisement
Guest User

Untitled

a guest
May 26th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. ```mysql
  2. mysql> update users set fname="Surendra" where id=4;
  3. Query OK, 1 row affected (0.00 sec)
  4. Rows matched: 1 Changed: 1 Warnings: 0
  5.  
  6. mysql> update users set fname="Darshan" where id=3;
  7. Query OK, 1 row affected (0.01 sec)
  8. Rows matched: 1 Changed: 1 Warnings: 0
  9.  
  10. mysql> select * from users;
  11. +----+-----------+----------+----------+-------------------------------+--------------+
  12. | id | fname | lname | uname | email | contact |
  13. +----+-----------+----------+----------+-------------------------------+--------------+
  14. | 1 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
  15. | 2 | Sandeep | E | sandeep | sandeepeswar8@gmail.com | 919739040038 |
  16. | 3 | Darshan | Sidar | darshan | sidardarshan@gmail.com | 917996917565 |
  17. | 4 | Surendra | Prajapat | surendra | surendrakgadwal@gmail.com | 918385894407 |
  18. | 5 | Mukesh | Jakhar | mukesh | mjakhar.kjahhar@gmail.com | 919772254140 |
  19. | 6 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
  20. +----+-----------+----------+----------+-------------------------------+--------------+
  21. 6 rows in set (0.00 sec)
  22.  
  23. mysql> delete from users where id=6;
  24. Query OK, 1 row affected (0.00 sec)
  25.  
  26. mysql> select * from users;
  27. +----+-----------+----------+----------+-------------------------------+--------------+
  28. | id | fname | lname | uname | email | contact |
  29. +----+-----------+----------+----------+-------------------------------+--------------+
  30. | 1 | Rishikesh | Agrawani | hygull | rishikesh0014051992@gmail.com | 917353787704 |
  31. | 2 | Sandeep | E | sandeep | sandeepeswar8@gmail.com | 919739040038 |
  32. | 3 | Darshan | Sidar | darshan | sidardarshan@gmail.com | 917996917565 |
  33. | 4 | Surendra | Prajapat | surendra | surendrakgadwal@gmail.com | 918385894407 |
  34. | 5 | Mukesh | Jakhar | mukesh | mjakhar.kjahhar@gmail.com | 919772254140 |
  35. +----+-----------+----------+----------+-------------------------------+--------------+
  36. 5 rows in set (0.00 sec)
  37.  
  38. mysql>
  39. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement