Create Database and Table in MYSQL

Опубликовано: 28 Сентябрь 2024
на канале: Coding with Sudhir

716

In this video we explain
how to create database, table in mysql8.0.28 client server thorough command

HOW TO INSTALL MYSQL 8.0.28
   • How to install MYSQL Server and Workb...

HOW TO UNINSTALL MYSQL
   • How to Uninstall MySQL Completely fro...

in this video we explain these command

how to show all database in mysql??
SHOW DATABASES;

how to use database?
USE DATABASE;

how to create table in mysql client server??
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

How to describe tables structure??

desc table_name.

how to show all table from database?
SHOW TABLES?;

how to insert value into table???
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

how to delete value?
DELETE FROM table_name WHERE condition;

how to drop table???
DROP TABLE table_name;

how to drop database??
DROP DATABASE database_name;

►Top Online Courses From Code Leaning
Mysql Tutorial for Beginners :
🔴 How to Search data From mysql in Netbeans
   • Java And MySQL - How To Insert Update...

🔴 How to Update data From mysql in Netbeans
   • Java And MySQL - How To Insert Update...

🔴 How to insert data From mysql in Netbeans
   • Java And MySQL - How To Insert Update...

🔴 How to delete data From mysql in Netbeans
   • Java And MySQL - How To Insert Update...

🔴 How to Find previous record in Netbeans
   • How to connect MySQL database in NetB...

🔴 How to Find Last record in Netbeans
   • How to connect MySQL database in NetB...

🔴 Record Navigation in java NetBeans
   • How to connect MySQL database in NetB...

🔴How to download mysql 8.0.29
   • How to install 🔴 MySQL 8.0.37 Server ...

🔴How to download netbeans 13
   • How to install java NetBeans IDE Late...

🔴How to Connection mysql 8.0.28 and NetBeans 12.6
   • How to connect MySQL database in NetB...

🔴How to download mysql 8.0.28
   • How to install MYSQL Server and Workb...

🔴How to download netbeans 12.6
   • How to install java NetBeans IDE Late...

🔴About mysql workbench
   • How to create database in MySQL Workb...

🔴About mysql client server
   • Create Database and Table in MYSQL

🔴Hotel management project in java netbeans
   • Hotel Management System Complete Proj...

🔴Loading Form designing in java netbeans
   • #02 Loading Screen for Hotel Manageme...

#createtable
#createtableinmysql
#createTableInMysql8.0.28
#createdatabase
#deletevaluefromtable
#dropdatabase
#deletetable
#inservalueintotable

How to create table in mysql
Create table in mysql
mysql tutorial
Create table in 8.0.28
install mysql
how to install mysql
Table Createtion in mysql
Create database in mysql
mysql tutorial for beginners
Table create
Database
Create delete insert table and database
Use database in mysql
mysql workbench
mysql databaselearn sqllearn mysqlsql coursesql for beginners