MySQL

Pridávací dotaz

Insert Into MyTable (Col1, Col2,…) Select Col1, Col2, … From MyView

Práca s dátumom

Funkcia Cast(‚str‘ as typ)
typ može byť:
BINARY [( N )]
CHAR [( N )]
DATE
DATETIME
DECIMAL [( M [, D ])]
Unsigned [integer]
TIME
Unsigned [integer]

SELECT * FROM inzerat where insert_date < CAST(‚2015–03–01‘ AS DATE)

SELECT ADDDATE(‚2015–02–01‘, 31)

SELECT adddate(now(),–31)

SELECT NOW(),CURDATE(),CURTIME()

SELECT now()

SELECT * from inzerat where insert_date between CAST(‚2015–02–07‘ AS DATE) AND CAST(‚2015–02–10‘ AS DATE)

Vytvorenie databázy

create DATABASE nazov_databazy

alebo hneď nastavým kódovanie a radenie

create DATABASE nazov_databazy DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_slovak_ci;

po vytvorení ju môžem zmeniť

ALTER DATABASE nazov_databazy DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_slovak_ci;

Vložiť stupajúce číslo

set @i := 0; update table set cislo = @i := @i+1

update spojene tabulky

update word inner join xxx on xxx.poradie = word.ID set word.word_uk = xxx.word_uk

between

SELECT * FROM word WHERE ID BETWEEN 3656 AND 5025

update word set word_sk = ‚Gulliver‘ where ID BETWEEN 3656 AND 5025

MySQL
########

Pridávací dotaz
*************
Insert Into MyTable (Col1, Col2,...)
Select Col1, Col2, ...
From MyView

Práca s dátumom
**********

Funkcia Cast('str' as typ)
 typ može byť:
 BINARY [( N )]
 CHAR [( N )]
 DATE
 DATETIME
 DECIMAL [( M [, D ])]
 Unsigned [integer]
 TIME
 Unsigned [integer]

SELECT * FROM `inzerat` where insert_date < CAST('2015-03-01' AS DATE)

SELECT ADDDATE('2015-02-01', 31)

SELECT adddate(now(),-31)

SELECT NOW(),CURDATE(),CURTIME()

SELECT now()

SELECT * from inzerat where insert_date between CAST('2015-02-07' AS DATE) AND CAST('2015-02-10' AS DATE)

Vytvorenie databázy
****
create DATABASE nazov_databazy

alebo hneď nastavým kódovanie a radenie

create DATABASE nazov_databazy 
DEFAULT CHARACTER SET utf8 
DEFAULT COLLATE utf8_slovak_ci;

po vytvorení ju môžem zmeniť

ALTER DATABASE nazov_databazy 
DEFAULT CHARACTER SET utf8 
DEFAULT COLLATE utf8_slovak_ci;

Vložiť stupajúce číslo
********

set @i := 0;
update table set cislo = @i := @i+1

update spojene tabulky
*********

update word inner join xxx on xxx.poradie = word.ID set word.word_uk = xxx.word_uk

between
*********
SELECT * FROM word WHERE ID BETWEEN 3656 AND 5025

update word set word_sk = 'Gulliver' where ID BETWEEN 3656 AND 5025