4sm7hkEb

1DROP DATABASE IF EXISTS ged;
2CREATE DATABASE ged;
3USE ged;
4
5CREATE TABLE  customers (
6    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
7    name VARCHAR(100) NOT NULL ,
8    email VARCHAR(100) NOT NULL ,
9    mobile VARCHAR(100) NOT NULL
10);
11
12CREATE TABLE bets (
13    bet_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
14    customer_id INT NOT NULL,
15    description VARCHAR(100),
16    odds INT, 
17    amount INT, 
18    FOREIGN KEY (customer_id) REFERENCES customers(id)
19);
20
21SHOW TABLES;
22DESCRIBE customers;
23DESCRIBE bets;
24SELECT * FROM customers LIMIT 10;