Vivify Ideas - Vezba 4

create.sql

-- Create table users with all needed fields
CREATE TABLE IF NOT EXISTS users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(50) UNIQUE,
password VARCHAR(50),
firstname VARCHAR(30),
lastname VARCHAR(30),
company VARCHAR(30),
country VARCHAR(30)
);

-- Insert new user
INSERT INTO users (email, password, firstname, lastname, company, country)
VALUES ('user@user.com', '123456', 'Name', 'Lastname', 'Vivify', 'Serbia');

-- Update user 
UPDATE users
SET firstname='Aleksandar', lastname='Babic'
WHERE email='user@user.com';

-- Delete user
DELETE FROM users
WHERE email='user@user.com';