· 6 years ago · Aug 09, 2019, 09:08 PM
1CREATE SCHEMA IF NOT EXISTS DB_SHOP;
2
3USE DB_SHOP;
4
5CREATE TABLE IF NOT EXISTS CUSTOMERS(
6 ID BIGINT UNSIGNED PRIMARY KEY ,
7 NAME VARCHAR(255),
8 SURNAME VARCHAR(255),
9 BIRTDATE DATE,
10 PHONE VARCHAR(50),
11 COUNTRY VARCHAR(50),
12 CITY VARCHAR(50),
13 DIRECTION VARCHAR(50),
14 POST_CODE VARCHAR(50)
15);
16
17SELECT * FROM CUSTOMERS;