Advertisement
Guest User

Untitled

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