Part 2 MySQL Workbench, create database and tables
DeepakTech
0:00 / 0:00
Part 2 MySQL Workbench, create database and tables
26 просмотров · 2 недели назад
DeepakTech
8 подписчиков
26 просмотров · 2 недели назад
MySQL Workbench, create database and tables
Here is the query
CREATE DATABASE registration;
USE registration;
CREATE TABLE registration
(
Id int,
name VARCHAR(20),
Gender CHAR(1),
birth DATE
);
SHOW TABLES;
INSERT INTO registration (Id,name, Gender, birth)
VALUES (1, 'Deepak','M','2026-09-02');
SELECT * FROM registration;
INSERT INTO registration (Id,name, Gender, birth)
VALUES
(2, 'Deepak2','M','2026-09-03'),
(3, 'Deepak3','M','2026-09-04');