LOCALHOST/SQL SERVER — KASUTAJAD JA ÕIGUSED

https://moodle.edu.ee/mod/assign/view.php?id=1563980&group=94590 Localhost CREATE USER 'MaksimDotskin'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON *.*…

Continue ReadingLOCALHOST/SQL SERVER — KASUTAJAD JA ÕIGUSED

Select laused

запрос на выборку значений из таблицы SELECT*FROM tabelinimi SELECT*FROM tabelinimi WHERE уловие create table Laps( lapsID int not null PRIMARY key AUTO_INCREMENT, lapsNimi varchar(20) not null, vanus int, synnilynn varchar(25),…

Continue ReadingSelect laused