Creating your First Database in MySQL - ECommerce Orders Database - Hindi / Urdu

Описание: #mysql #database #sql #learnsql #sqlhindi #sqlfordatascience
Tutorial Code:
TRUNCATE tblcustomers; -- Empty the table
In table we can create a Primary Key which is auto_increment

Price / Cost / Money : DECIMAL

Sellers : SellerID, SellerName, City, ContactNumber, Email, Password

String ( Text - Alphanumeric ). : CHAR, VARCHAR, TEXT etc.
--- actual command
CREATE TABLE Sellers(
SellerID INT(5) PRIMARY KEY AUTO_INCREMENT,
SellerName VARCHAR(50),
City VARCHAR(50),
ContactNumber VARCHAR(13),
Email VARCHAR(50),
OpeningBalance DECIMAL(15,2),
Password VARCHAR(50)
)
Categories : CategoryID, CategoryName, Description

CREATE TABLE plants_shopping.Categories(
CategoryID INT(2) PRIMARY KEY AUTO_INCREMENT,
CategoryName VARCHAR(50),
Description TEXT
)


In Products Table CategoryID and SellerID are Foreign Keys

Their details can be fetched from Categories and Sellers Table respectively