uXCvbG47

1CREATE SCHEMA IF NOT EXISTS db_customers;
2USE db_customers;
3
4CREATE TABLE IF NOT EXISTS customers(
5	id INT UNSIGNED NOT NULL AUTO_INCREMENT,  
6	name VARCHAR(100) NOT NULL,  
7	surname VARCHAR(100) NOT NULL,
8    dni VARCHAR(100) NOT NULL,
9	birthDate DATE NOT NULL, # DATE YYYY-MM-DD
10    phone int NOT NULL,
11    country VARCHAR(100) NOT NULL,
12    city VARCHAR(100) NOT NULL,
13    direction VARCHAR(100) NOT NULL,
14    PRIMARY KEY (`id`)
15);
16
17INSERT INTO customers (name, surname, dni, birthDate, phone, country, city, direction) 
18VALUES ('IVAN', 'ROCA', '12345678A', '1970-06-11', 666666666, 'ESPAÑA', 'MADRID', 'C/BAILEN 75 1º 2ª');
19INSERT INTO customers (name, surname, dni, birthDate, phone, country, city, direction) 
20VALUES ('DAVID', 'GONZALEZ', '12345678A', '1991-06-11', 666666666, 'ESPAÑA', 'BARCELONA', 'AV. MADRID 33 12º 6ª');
21
22SELECT * FROM customers;