QJseSCfe

1CREATE USER IF NOT EXISTS camel PASSWORD 'camel'
2
3ALTER USER camel ADMIN TRUE;
4
5CREATE SCHEMA IF NOT EXISTS CAMEL_TEST_DB AUTHORIZATION camel;
6
7CREATE TABLE CAMEL_TEST_DB.CUSTOMERS (
8    ID BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY,
9    FIRST_NAME VARCHAR(55),
10    LAST_NAME VARCHAR(55),
11    EMAIL VARCHAR(55),
12    BIRTH_DATE DATE)
13
14INSERT INTO CAMEL_TEST_DB.CUSTOMERS (FIRST_NAME, LAST_NAME , EMAIL, BIRTH_DATE)  VALUES('Rafael',  'Soares', 'teste@gmail.com', '1983-09-29') ;
15INSERT INTO CAMEL_TEST_DB.CUSTOMERS (FIRST_NAME, LAST_NAME , EMAIL, BIRTH_DATE)  VALUES('Tuelho',  'Rafael', 'teste@gmail.com', '1983-09-29') ;
16INSERT INTO CAMEL_TEST_DB.CUSTOMERS (FIRST_NAME, LAST_NAME , EMAIL, BIRTH_DATE)  VALUES('Henrique',  'Torres', 'teste@gmail.com', '1983-09-29'); 
17INSERT INTO CAMEL_TEST_DB.CUSTOMERS (FIRST_NAME, LAST_NAME , EMAIL, BIRTH_DATE)  VALUES('Fabiane',  'Soares', 'teste@gmail.com', '1983-09-29'); 
18INSERT INTO CAMEL_TEST_DB.CUSTOMERS (FIRST_NAME, LAST_NAME , EMAIL, BIRTH_DATE)  VALUES('John',  'Smith', 'teste@gmail.com', '1983-09-29'); 
19
20SELECT * FROM CAMEL_TEST_DB.CUSTOMERS;