Tugas Kuliah

20190924.sql

-- DDL

-- Create
CREATE TABLE `users` (`id` bigint unsigned not null auto_increment primary key, 
                      `name` varchar(255) not null, 
                      `email` varchar(255) not null, 
                      `email_verified_at` timestamp null, 
                      `password` varchar(255) not null, 
                      `remember_token` varchar(100) null, 
                      `created_at` timestamp null, 
                      `updated_at` timestamp null
                    ) default character set utf8mb4 collate 'utf8mb4_unicode_ci';

-- Update Schema
ALTER TABLE `users` ADD UNIQUE `users_email_unique`(`email`);

-- Delete Table
DROP TABLE users;

-- DML

-- Insert 
INSERT INTO `users` (`name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) 
VALUES ('Muhamad Ilham Arrouf', '[email protected]', '2019-09-24 11:25:49', 'nsadjfsj', 'NULL', '2019-09-24 11:25:56', '2019-09-24 11:25:59')

-- Update
UPDATE `users` t SET t.`email` = '[email protected]' WHERE t.`id` = 1

-- Delete
improvisasi