SQL nodarbiba 5

Datu manipulācijas komandas

SELECT - izvēlas datus, 'result set' - rezultatu tabula

UPDATE - atjauno esošus datus, rezultātu neatgriež

DELETE - izdzeš ierakstu

INSERT INTO - ievieto datus datu bāze, noradītajā tabulā

select `username` from `userlist`;

SELECT `user` FROM `users`;

SELECT DISTINCT `email` FROM `userlist`; 

SELECT `email` FROM `userlist` WHERE `id`='2'; 

SELECT `email` FROM `userlist` WHERE `id`<'3'; 
SELECT `email` FROM `userlist` WHERE `id`!='3'; 
SELECT `email` FROM `userlist` WHERE `id` BETWEEN '2' AND '4'; 
SELECT `email` FROM `userlist` WHERE `email` LIKE '%inbox.lv'; 
SELECT `email` FROM `users` WHERE `email` LIKE 'inbox%';
SELECT `email` FROM `userlist` WHERE `email` LIKE '%info_@inbox.lv%'; (info1@inbox.lv un info2@inbox.lv) _ = 1 simbols
 
SELECT `email` FROM `users` WHERE `email` LIKE '%info[2345]@inbox.lv%'; [vienam no noraditam simboliem]
SELECT `email` FROM `users` WHERE `email` LIKE '%info[^2345]@inbox.lv%'; [kas neatbilst 2, 3, 4, vai 5]
 
SELECT `email` FROM `users` WHERE `email` LIKE '%info[!2345]@inbox.lv%'; [kas neatbilst]
 SELECT `email` FROM `userlist` WHERE `ID` IN ('2','4'); 
SELECT `email` FROM `userlist` WHERE `username`='viens' AND `email`='viens@'; 
SELECT `email` FROM `users` WHERE `name`='' AND `email`='' OR `email`='';
 
SELECT `email` FROM `users` WHERE `name`='' AND (`email`='' OR `email`='');
 SELECT `email` FROM `userlist` WHERE `id`!='0' ORDER BY `email`; 
SELECT `email` FROM `users` WHERE `id`!='0' ORDER BY `id` ASC; (AUGOŠA SECĪBĀ)
 SELECT `email` FROM `users` WHERE `id`!='0' ORDER BY `id` DESC; (KRITOŠĀ SECĪBĀ)
 SELECT `email` FROM `userlist` WHERE `id`!='0' ORDER BY `id`,`email`,`username` DESC; 
INSERT INTO `userlist` (`username`,`email`,`pasw`) VALUES 
('User1','email@mail.com','641a37f8ca1adc2470302acdb223b13c288eecd7'); ( , or ;)