MariusTheMaster

trying SQL #1

Sep 19th, 2023 (edited)
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 7.58 KB | None | 0 0
  1. One to one, many to many
  2. Press Ctrl+Enter to execute query
  3. create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
  4. create database people
  5. select * from kab212_7
  6. create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
  7. create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
  8. SELECT * FROM `people`
  9. drop table people;
  10. create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
  11. SELECT * FROM `people`
  12. Collapse Requery Edit Database : kab212_7_people Queried time : 12:37:30
  13. create table personal_code(code_id smallint(10) primary key auto_increment,code smallint(10), person_id smallint(10));
  14. SELECT * FROM `personal_code`
  15. SELECT * FROM `personal_code`
  16. drop table personal_code;
  17. Collapse Requery Edit Database : kab212_7_people Queried time : 12:56:48
  18. create table personal_code(code_id smallint(10) primary key auto_increment,code smallint(10), person_id smallint(10), foreign key (person_id) references people(person_id));
  19. SELECT * FROM `personal_code`
  20. SELECT * FROM `people`
  21. SELECT * FROM `personal_code`
  22. SELECT * FROM `people`
  23. SELECT * FROM `people`
  24. SELECT * FROM `personal_code`
  25. select * from kab212_7
  26. SELECT * FROM `people`
  27. create table car_factory(factory_id smallint(10) primary key auto_increment, factory_name varchar(30), location varchar(30));
  28. create table car_model(model_id smallint(10) primary key auto_increment, model_name varchar(30), factory_id smallint(10), foreign key car_model(factory_id) references car_factory(factory_id));
  29. SELECT * FROM `car_factory`
  30. SELECT * FROM `car_model`
  31. create database kab212_7_shop;
  32. create table customers(customer_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
  33. create table orders(order_id smallint(10) primary key auto_increment, number smallint(30), product_amount smallint(999), customer_id smallint(10), foreign key Orders(customer_id) references Customers(customer_id));
  34. create table orders(order_id smallint(10) primary key auto_increment, number smallint(30), product_amount smallint(255), customer_id smallint(10), foreign key Orders(customer_id) references Customers(customer_id));
  35. create table orders(order_id smallint(10) primary key auto_increment, number smallint(30), product_amount smallint(999), customer_id smallint(10), foreign key orders(customer_id) references customers(customer_id));
  36. create table orders(order_id smallint(10) primary key auto_increment, number smallint(30), product_amount smallint(255), customer_id smallint(10), foreign key orders(customer_id) references customers(customer_id));
  37. SELECT * FROM `orders`
  38. SELECT * FROM `customers`
  39. create table products(product_id smallint(10) primary key auto_increment, product_name varchar(50), order_id smallint(10), foreign key products(order_id) references orders(order_id));
  40. SELECT * FROM `customers`
  41. SELECT * FROM `orders`
  42. SELECT * FROM `products`
  43. create database kab212_7_school;
  44. create table students(student_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
  45. Collapse Edit Query failed
  46. create table junction_table(junction_id smallint(10) primary key auto_increment, student_id smallint(10), subject_id smallint(10), foreign key (student_id) references students(student_id), foreign key (subject_id) references subjects(subject_id));
  47. create table students(student_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
  48. create table junction_table(junction_id smallint(10) primary key auto_increment, student_id smallint(10), subject_id smallint(10), foreign key (student_id) references students(student_id), foreign key (subject_id) references subjects(subject_id));
  49. create table subjects(subject_id smallint(10) primary key auto_increment, subject_name varchar(30), subject_teacher varchar(30));
  50. create table junction_table(junction_id smallint(10) primary key auto_increment, student_id smallint(10), subject_id smallint(10), foreign key (student_id) references students(student_id), foreign key (subject_id) references subjects(subject_id));
  51. drop table students;
  52. SELECT * FROM `junction_table`
  53. SELECT * FROM `students`
  54. SELECT * FROM `subjects`
  55. describe junction_table;
  56.  
  57. Press Ctrl+Enter to execute query
  58. SELECT * FROM `mokiniai`
  59. CREATE DATABASE cats;
  60. CREATE DATABASE dogs;
  61. CREATE DATABASE aliens;
  62. CREATE DATABASE weed;
  63. SELECT * FROM `mokiniai`
  64. SELECT * FROM `mokiniai`
  65. SELECT * FROM `mokiniai`
  66. SELECT * FROM `mokiniai`
  67. SELECT * FROM `kitm`
  68. SELECT DATABASE
  69. SELECT DATABASE `kitm`
  70. USE `kitm`;
  71. SELECT * FROM mokiniai;
  72. UPDATE mokiniai SET email'[email protected]' id=3;
  73. UPDATE mokiniai SET email='[email protected]' id=3;
  74. UPDATE mokiniai SET email'[email protected]' WHERE id=3;
  75. UPDATE mokiniai SET email='[email protected]' WHERE id=3;
  76. SELECT * FROM `mokiniai`
  77. SELECT * FROM email WHERE name LIKE '%inga.papinga%';
  78. SELECT * FROM mokiniai WHERE email LIKE '%inga.papinga%';
  79. SELECT * FROM mokiniai;
  80. SELECT DISTINCT fin_date FROM mokiniai;
  81. SELECT * FROM `mokiniai`
  82. SELECT fin_date FROM mokiniai ORDER BY fin_date ASC;
  83. SELECT * FROM mokiniai;
  84. SELECT fin_date FROM mokiniai LIMIT 5 OFFSET 3;
  85. SELECT * FROM `mokiniai`
  86. ALTER TABLE mokiniai ADD qualification varchar(255);
  87. SELECT * FROM `mokiniai`
  88. SELECT * FROM `mokiniai`
  89. SELECT * FROM `mokiniai`
  90.  
  91.  
  92.  
  93. Press Ctrl+Enter to execute query
  94. create database kab212_11_JavaProgramuotojai;
  95. SELECT * FROM `Automobiliai`
  96. SELECT * FROM `parduotuve`
  97. SELECT * FROM `parduotuve`
  98. SELECT * FROM `Automobiliai`
  99. create table parduotuve(id smallint auto_increment primary key, pavadinimas varchar(55) not null, gamintojas varchar(55) not null, barkodas varchar(55) not null, kilmesSalis varchar(55) not null, kainaBeNuolaidos smallint not null, nuolaidosProcentas smallint not null);
  100. SELECT * FROM `parduotuve`
  101. SELECT * FROM `parduotuve`
  102. SELECT * FROM `parduotuve`
  103. SELECT * FROM `parduotuve`
  104. SELECT * FROM `parduotuve`
  105. SELECT * FROM `parduotuve`
  106. alter table parduotuve add naujas_stulpelis varchar(55) not null;
  107. SELECT * FROM `parduotuve`
  108. select * from parduotuve limit 3;
  109. SELECT * FROM `parduotuve`
  110. select * from parduotuve where kainaBeNuolaidos>12, nuolaidosProcentas>30 order by pavadinimas desc;
  111. SELECT * FROM `parduotuve`
  112. select * from parduotuve where kainaBeNuolaidos > 12, nuolaidosProcentas > 30 order by pavadinimas desc;
  113. SELECT * FROM `parduotuve`
  114. select * from parduotuve where kainaBeNuolaidos>12 and nuolaidosProcentas>30 order by pavadinimas desc;
  115. select parduotuve from parduotuve where kainaBeNuolaidos>12, nuolaidosProcentas>30 order by kainaBeNuolaidos desc;
  116. SELECT * FROM `parduotuve`
  117. select kainaBeNuolaidos from parduotuve where kainaBeNuolaidos>12 and nuolaidosProcentas>30 order by kainaBeNuolaidos desc;
  118. SELECT * FROM `parduotuve`
  119. select distinct gamintojas from parduotuve;
  120. SELECT * FROM `parduotuve`
  121. select pavadinimas, gamintojas from parduotuve order by length(gamintojas);
  122. select length(pavadinimas, gamintojas) as len from parduotuve having len between(4 and 7);
  123. SELECT * FROM `parduotuve`
  124. select length(pavadinimas gamintojas) as len from parduotuve having len between(4 and 7);
  125. SELECT * FROM `parduotuve`
  126. select length(gamintojas) as len from parduotuve having len between(4 and 7);
  127. SELECT * FROM `parduotuve`
  128. update parduotuve set kilmesSalis='unknown' where gamintojas=haribo or gamintojas=pedigree;
  129. SELECT * FROM `parduotuve`
  130. update parduotuve set kilmesSalis='unknown' where gamintojas='haribo' or gamintojas='pedigree';
  131. SELECT * FROM `parduotuve`
Tags: programming
Add Comment
Please, Sign In to add comment