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;
UPDATE mokiniai SET email'[email protected]' id=3;
UPDATE mokiniai SET email='[email protected]' id=3;
UPDATE mokiniai SET email'[email protected]' WHERE id=3;
UPDATE mokiniai SET email='[email protected]' WHERE id=3;
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`
Comments