Timur Bashirov Portfolio

et

выбрать все поля из таблицы с именем laps

select * from laps

 выбрать из таблицы table_name все поля

  1. Tingimused
    Näidata ainult nimi ja pikkus
select nimi,pikkus from laps
select nimi,pikkus
from laps 
where pikkus>=150;
select nimi,pikkus
from laps
where pikkus >=150
order by pikkus desc;
select nimi
from laps
where nimi like 'M%';
select nimi
from laps
where nimi like '%E%';
select nimi, vanus
from laps
where vanus between 5 and 16;

or

select nimi, vanus
from laps
where vanus >= 5 and vanus <=16;

2. Agregaatfunktsioonid

SUM()
MIN()
MAX()
AVG()
COUNT()

select AVG(pikkus) AS keskmine_pikkus
from laps
select sum(vanus) as sum_vanus
from laps
select min(vanus) as min_vanus,max(vanus) as max_vanus
from laps
select count(*) as lastearv
from laps
where synnilinn like 'Tallinn'
select nimi, vanus
from laps
order by vanus DESC;
select * from laps, loom
where laps.lapsID=loom.lapsID

or

Select * from laps inner join loom
on laps.lapsID=loom.lapsID;
Select * from laps inner join loom
on laps.lapsID=loom.lapsID;
select lo.loomaNimi, l.nimi
from laps l inner join loom lo
on l.lapsID=lo.lapsID;
select lo.loomaNimi, l.nimi
from laps l inner join loom lo
on l.lapsID=lo.lapsID
where lo.loomaNimi like '%kass%';
UPDATE laps
SET pikkus=pikkus*1.1

увеличиваем рост всех детей на 10%

UPDATE laps
SET synnilinn='Tallinn'

изменяем столбец synnilinn и установить значение Tallinn

UPDATE laps
set vanus=24,pikkus=158;
select nimi
from laps
where vanus=24 and pikkus <150
select top 3 nimi, pikkus
from laps
order by pikkus desc

SQL и XXAMP

select nimi,pikkus 
from laps 
order by pikkus desc
limit 3;