· 7 years ago · Jan 10, 2019, 09:02 AM
1CREATE DATABASE humans;
2USE humans;
3
4CREATE TABLE IF NOT EXISTS `humans`.`covek` (
5 `ime` VARCHAR(20) NOT NULL,
6 `prezime` VARCHAR(25) NOT NULL,
7 `drodjenja` DATE NOT NULL,
8 `visina` FLOAT NOT NULL
9);
10
11DROP TABLE covek;
12
13DROP DATABASE humans;
14
15SHOW TABLEs;