API tools faq
paste
Advertisement
GamerBhai02

DBMS EXP 1

GamerBhai02
Mar 10th, 2025 (edited)
280
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.08 KB | Source Code | 0 0
raw download clone embed print report
  1. show databases;
  2. create database experiment;
  3. use experiment;
  4. create table student(ID int,Name varchar(30),Age int);
  5. alter table student add Grade varchar(3);
  6. desc student;
  7. insert into student (ID,Name,Age,Grade) values(101,'John Doe',25,'A'),(201,'Willliam Turber',30,'O'),(301,'Olivia',19,'B'),(401,'Alice Brown',21,'A'),(501,'Sheldon Cooper',20,'S');
  8. select * from student;
  9. set sql_safe_updates=0;
  10. update student set  age=21 where ID=101;
  11. delete from student where id=101;
  12. select * from student;
  13. select * from student where age>=19;
  14. select * from student where Name='Willliam Turber' or Name='Alice Brown';
  15. select * from student where Name in ('Willliam Turber','Alice Brown');
  16. select * from student;
  17. select * from student where Grade in ('A','B') and age>=20;
  18. select * from student where Age between 20 and 25;
  19. select * from student where Age<20;
  20. select * from student where Grade>'B';
  21.  
  22. Output:
  23. +-------+-------------+------+-----+---------+-------+
  24. | Field | Type        | Null | Key | Default | Extra |
  25. +-------+-------------+------+-----+---------+-------+
  26. | ID    | int         | YES  |     | NULL    |       |
  27. | Name  | varchar(30) | YES  |     | NULL    |       |
  28. | Age   | int         | YES  |     | NULL    |       |
  29. | Grade | varchar(3)  | YES  |     | NULL    |       |
  30. +-------+-------------+------+-----+---------+-------+
  31. +------+-----------------+------+-------+
  32. | ID   | Name            | Age  | Grade |
  33. +------+-----------------+------+-------+
  34. |  101 | John Doe        |   25 | A     |
  35. |  201 | Willliam Turber |   30 | O     |
  36. |  301 | Olivia          |   19 | B     |
  37. |  401 | Alice Brown     |   21 | A     |
  38. |  501 | Sheldon Cooper  |   20 | S     |
  39. +------+-----------------+------+-------+
  40. +------+-----------------+------+-------+
  41. | ID   | Name            | Age  | Grade |
  42. +------+-----------------+------+-------+
  43. |  201 | Willliam Turber |   30 | O     |
  44. |  301 | Olivia          |   19 | B     |
  45. |  401 | Alice Brown     |   21 | A     |
  46. |  501 | Sheldon Cooper  |   20 | S     |
  47. +------+-----------------+------+-------+
  48. +------+-----------------+------+-------+
  49. | ID   | Name            | Age  | Grade |
  50. +------+-----------------+------+-------+
  51. |  201 | Willliam Turber |   30 | O     |
  52. |  301 | Olivia          |   19 | B     |
  53. |  401 | Alice Brown     |   21 | A     |
  54. |  501 | Sheldon Cooper  |   20 | S     |
  55. +------+-----------------+------+-------+
  56. +------+-----------------+------+-------+
  57. | ID   | Name            | Age  | Grade |
  58. +------+-----------------+------+-------+
  59. |  201 | Willliam Turber |   30 | O     |
  60. |  401 | Alice Brown     |   21 | A     |
  61. +------+-----------------+------+-------+
  62. +------+-----------------+------+-------+
  63. | ID   | Name            | Age  | Grade |
  64. +------+-----------------+------+-------+
  65. |  201 | Willliam Turber |   30 | O     |
  66. |  401 | Alice Brown     |   21 | A     |
  67. +------+-----------------+------+-------+
  68. +------+-----------------+------+-------+
  69. | ID   | Name            | Age  | Grade |
  70. +------+-----------------+------+-------+
  71. |  201 | Willliam Turber |   30 | O     |
  72. |  301 | Olivia          |   19 | B     |
  73. |  401 | Alice Brown     |   21 | A     |
  74. |  501 | Sheldon Cooper  |   20 | S     |
  75. +------+-----------------+------+-------+
  76. +------+-------------+------+-------+
  77. | ID   | Name        | Age  | Grade |
  78. +------+-------------+------+-------+
  79. |  401 | Alice Brown |   21 | A     |
  80. +------+-------------+------+-------+
  81. +------+----------------+------+-------+
  82. | ID   | Name           | Age  | Grade |
  83. +------+----------------+------+-------+
  84. |  401 | Alice Brown    |   21 | A     |
  85. |  501 | Sheldon Cooper |   20 | S     |
  86. +------+----------------+------+-------+
  87. +------+--------+------+-------+
  88. | ID   | Name   | Age  | Grade |
  89. +------+--------+------+-------+
  90. |  301 | Olivia |   19 | B     |
  91. +------+--------+------+-------+
  92. +------+-----------------+------+-------+
  93. | ID   | Name            | Age  | Grade |
  94. +------+-----------------+------+-------+
  95. |  201 | Willliam Turber |   30 | O     |
  96. |  501 | Sheldon Cooper  |   20 | S     |
  97. +------+-----------------+------+-------+
Tags: Experiment 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!