Master MySQL Easily: Complete Analysis of 30 Basic Operations Statements

1. Create a database

CREATE DATABASE mydatabase;

1. Drop a database

DROP DATABASE mydatabase;

1. Create a table

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL,

email VARCHAR(100) NOT NULL

);

1. Drop a table

DROP TABLE users;

1. Insert a record into a table

INSERT INTO users (username, email) VALUES (‘john_doe’, ‘john@example.com’);

1. Update records in a table

UPDATE users SET email = ‘new_email@example.com’ WHERE username = ‘john_doe’;

1. Delete records from a table

DELETE FROM users …

analysis basic create database email key master mysql null operations record table