MySQL Installation & Workbench

 












Comments

Post a Comment

Popular posts from this blog

MySQL DELETE

Image
 How to work DELETE: Examples: Syntax: Code: CREATE TABLE student ( id INT NOT NULL UNIQUE , name VARCHAR ( 50 ) NOT NULL , age INT NOT NULL CHECK ( age >= 18 ) , gender VARCHAR ( 1 ) NOT NULL , phone VARCHAR ( 10 ) NOT NULL UNIQUE , city VARCHAR ( 15 ) NOT NULL DEFAULT 'MUL' ) ; Insert Records INSERT INTO student ( id , name , age , gender , phone , city ) VALUES ( 1 , "Asif" , "13" , "M" , "4022155" , "BHW" ) , ( 2 , "Saqib" , "21" , "M" , "4034421" , "Mul" ) , ( 3 , "Salman Khan" , "20" , "M" , "4056221" , "Mul" ) , ( 4 , "Maryam" , "18" , "F" , "4022155" , "DG Khan" ) , ( 5 , "Hamza" , "22" , "M" , "4025221" , "Mul" ) , ( 6 , "Anela" , "21" , "F" , ...
Read more

MySQL PRIMARY KEY & FOREIGN KEY

Image
 How to work PRIMARY KEY & FOREIGN KEY Example: Primary Key Syntax: Alter Syntax: Works: How to link Primary Key to Foreign Key: Foreign Key Syntax: Code: CREATE TABLE city(     cid INT NOT NULL AUTO_INCREMENT,     cityname VARCHAR(50) NOT NULL,     PRIMARY KEY (cid) ); insert records in "city" table INSERT INTO city(cityname) VALUES('Mul'), ('Lhr'), ('Mul'), ('Bhw'), ('Mul'); create table "personal" and insert records CREATE TABLE personal( id INT NOT NULL, name VARCHAR(50) NOT NULL,         percentage INT NOT NULL, age INT NOT NULL, gender VARCHAR(1) NOT NULL, city INT NOT NULL,         PRIMARY KEY (id), FOREIGN KEY (city) REFERENCES City (cid)   ); INSERT INTO personal(id,name,percentage,age,gender,city) VALUES (1,"Aqib","45","13","M",1), (2,"Sheikh Anum","56","21","F",2), (3,"Salman Khan","62","20",...
Read more

MySQL INNER JOIN

Image
Types of Join What is Inner  Join?  How to work Inner Join? Inner Join Syntax: Code: CREATE TABLE city( cid INT NOT NULL AUTO_INCREMENT, cityname VARCHAR(50) NOT NULL, PRIMARY KEY (cid) ); insert records in "city" table INSERT INTO city(cityname) VALUES('Mul'), ('Lhr'), ('Mul'), ('Bhw'), ('Mul'); create table "personal" and insert records CREATE TABLE personal( id INT NOT NULL, name VARCHAR(50) NOT NULL, percentage INT NOT NULL, age INT NOT NULL, gender VARCHAR(1) NOT NULL, city INT NOT NULL, PRIMARY KEY (id), FOREIGN KEY (city) REFERENCES City (cid) ); INSERT INTO personal(id,name,percentage,age,gender,city) VALUES (1,"Aqib","45","13","M",1), (2,"Sheikh Anum","56","21","F",2), (3,"Salman Khan","62","20","M",1), (4,"Aqeela","47","18","F...
Read more