8nyicJBW

1-- Create table users with all needed fields
2CREATE TABLE IF NOT EXISTS users (
3id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
4email VARCHAR(50) UNIQUE,
5password VARCHAR(50),
6firstname VARCHAR(30),
7lastname VARCHAR(30),
8company VARCHAR(30),
9country VARCHAR(30)
10);
11
12-- Insert new user
13INSERT INTO users (email, password, firstname, lastname, company, country)
14VALUES ('user@user.com', '123456', 'Name', 'Lastname', 'Vivify', 'Serbia');
15
16-- Update user 
17UPDATE users
18SET firstname='Aleksandar', lastname='Babic'
19WHERE email='user@user.com';
20
21-- Delete user
22DELETE FROM users
23WHERE email='user@user.com';