Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- One to one, many to many
- Press Ctrl+Enter to execute query
- create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
- create database people
- select * from kab212_7
- create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
- create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
- SELECT * FROM `people`
- drop table people;
- create table people(person_id smallint(10) primary key auto_increment,name varchar(30), lastname varchar(30));
- SELECT * FROM `people`
- Collapse Requery Edit Database : kab212_7_people Queried time : 12:37:30
- create table personal_code(code_id smallint(10) primary key auto_increment,code smallint(10), person_id smallint(10));
- SELECT * FROM `personal_code`
- SELECT * FROM `personal_code`
- drop table personal_code;
- Collapse Requery Edit Database : kab212_7_people Queried time : 12:56:48
- 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));
- SELECT * FROM `personal_code`
- SELECT * FROM `people`
- SELECT * FROM `personal_code`
- SELECT * FROM `people`
- SELECT * FROM `people`
- SELECT * FROM `personal_code`
- select * from kab212_7
- SELECT * FROM `people`
- create table car_factory(factory_id smallint(10) primary key auto_increment, factory_name varchar(30), location varchar(30));
- 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));
- SELECT * FROM `car_factory`
- SELECT * FROM `car_model`
- create database kab212_7_shop;
- create table customers(customer_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
- 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));
- 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));
- 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));
- 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));
- SELECT * FROM `orders`
- SELECT * FROM `customers`
- 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));
- SELECT * FROM `customers`
- SELECT * FROM `orders`
- SELECT * FROM `products`
- create database kab212_7_school;
- create table students(student_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
- Collapse Edit Query failed
- 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));
- create table students(student_id smallint(10) primary key auto_increment, name varchar(30), lastname varchar(30), email varchar(30));
- 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));
- create table subjects(subject_id smallint(10) primary key auto_increment, subject_name varchar(30), subject_teacher varchar(30));
- 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));
- drop table students;
- SELECT * FROM `junction_table`
- SELECT * FROM `students`
- SELECT * FROM `subjects`
- describe junction_table;
- Press Ctrl+Enter to execute query
- SELECT * FROM `mokiniai`
- CREATE DATABASE cats;
- CREATE DATABASE dogs;
- CREATE DATABASE aliens;
- CREATE DATABASE weed;
- SELECT * FROM `mokiniai`
- SELECT * FROM `mokiniai`
- SELECT * FROM `mokiniai`
- SELECT * FROM `mokiniai`
- SELECT * FROM `kitm`
- SELECT DATABASE
- SELECT DATABASE `kitm`
- USE `kitm`;
- SELECT * FROM mokiniai;
- SELECT * FROM `mokiniai`
- SELECT * FROM email WHERE name LIKE '%inga.papinga%';
- SELECT * FROM mokiniai WHERE email LIKE '%inga.papinga%';
- SELECT * FROM mokiniai;
- SELECT DISTINCT fin_date FROM mokiniai;
- SELECT * FROM `mokiniai`
- SELECT fin_date FROM mokiniai ORDER BY fin_date ASC;
- SELECT * FROM mokiniai;
- SELECT fin_date FROM mokiniai LIMIT 5 OFFSET 3;
- SELECT * FROM `mokiniai`
- ALTER TABLE mokiniai ADD qualification varchar(255);
- SELECT * FROM `mokiniai`
- SELECT * FROM `mokiniai`
- SELECT * FROM `mokiniai`
- Press Ctrl+Enter to execute query
- create database kab212_11_JavaProgramuotojai;
- SELECT * FROM `Automobiliai`
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- SELECT * FROM `Automobiliai`
- 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);
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- SELECT * FROM `parduotuve`
- alter table parduotuve add naujas_stulpelis varchar(55) not null;
- SELECT * FROM `parduotuve`
- select * from parduotuve limit 3;
- SELECT * FROM `parduotuve`
- select * from parduotuve where kainaBeNuolaidos>12, nuolaidosProcentas>30 order by pavadinimas desc;
- SELECT * FROM `parduotuve`
- select * from parduotuve where kainaBeNuolaidos > 12, nuolaidosProcentas > 30 order by pavadinimas desc;
- SELECT * FROM `parduotuve`
- select * from parduotuve where kainaBeNuolaidos>12 and nuolaidosProcentas>30 order by pavadinimas desc;
- select parduotuve from parduotuve where kainaBeNuolaidos>12, nuolaidosProcentas>30 order by kainaBeNuolaidos desc;
- SELECT * FROM `parduotuve`
- select kainaBeNuolaidos from parduotuve where kainaBeNuolaidos>12 and nuolaidosProcentas>30 order by kainaBeNuolaidos desc;
- SELECT * FROM `parduotuve`
- select distinct gamintojas from parduotuve;
- SELECT * FROM `parduotuve`
- select pavadinimas, gamintojas from parduotuve order by length(gamintojas);
- select length(pavadinimas, gamintojas) as len from parduotuve having len between(4 and 7);
- SELECT * FROM `parduotuve`
- select length(pavadinimas gamintojas) as len from parduotuve having len between(4 and 7);
- SELECT * FROM `parduotuve`
- select length(gamintojas) as len from parduotuve having len between(4 and 7);
- SELECT * FROM `parduotuve`
- update parduotuve set kilmesSalis='unknown' where gamintojas=haribo or gamintojas=pedigree;
- SELECT * FROM `parduotuve`
- update parduotuve set kilmesSalis='unknown' where gamintojas='haribo' or gamintojas='pedigree';
- SELECT * FROM `parduotuve`
Add Comment
Please, Sign In to add comment