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