How to create a Table in MySQL Workbench
This tutorial covers the steps required to create and update your table schema using MySQL Workbench.
⏱️ TIMESTAMPS
00:00:00 What is a table?
00:00:20 Table Commands
00:02:09 CREATE
00:04:06 SELECT
00:04:20 RENAME
00:04:42 DROP
00:05:01 ALTER
00:08:39 SHOW
00:09:06 DESCRIBE
💻 MySQL Commands
=============================
CREATE DATABASE IF NOT EXISTS books;
USE books;
CREATE TABLE books (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(150) NOT NULL,
author VARCHAR(100) NOT NULL,
genre VARCHAR(50),
price DECIMAL(8,2),
published_year INT
);
SELECT * FROM books;
RENAME TABLE books TO novels;
DROP TABLE novels;
ALTER TABLE novels
ADD COLUMN isbn VARCHAR(20);
ALTER TABLE novels
RENAME COLUMN published_year TO year;
ALTER TABLE novels
MODIFY price DECIMAL(10,2);
ALTER TABLE novels
MODIFY isbn VARCHAR(20)
NOT NULL FIRST;
ALTER TABLE novels
MODIFY isbn VARCHAR(20)
NOT NULL AFTER year;
ALTER TABLE novels
DROP COLUMN isbn;
SHOW TABLES;
DESCRIBE novels;
=============================
🔔 SUBSCRIBE ON YOUTUBE
@csbrain
#mysql #sql #sqltable #AI #Machine Learning