ub4HE926

1-- DROP SCHEMA IF EXISTS `tutorial`;
2-- DROP TABLE `tutorial`.`product` ;
3-- create schema `tutorial`;
4-- USE `tutorial`;
5
6
7-- CREATE TABLE IF NOT EXISTS `tutorial`.`product`(
8--   `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
9--   `name` VARCHAR(40) DEFAULT NULL,
10--   `description` VARCHAR(255) DEFAULT NULL,
11--   `unit_price` DECIMAL(13,2) DEFAULT NULL,
12--   `units_in_stock` INT(11) DEFAULT NULL 
13--   )
14  
15  INSERT INTO tutorial.product 
16  (name,description,unit_price,units_in_stock)
17  VALUES('Test','Bardzo dobry produkt',5.32, 5);