Скачать с ютуб Creating your First Database in MySQL - ECommerce Orders Database - Hindi / Urdu в хорошем качестве

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