MySQL Installation & Workbench

 












Comments

Post a Comment

Popular posts from this blog

MySQL VIEW

Image
 How to work View In MySql: INNER Join Syntax: Create View Syntax: Code: 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,     courses INT NOT NULL,     PRIMARY KEY (id), FOREIGN KEY (city) REFERENCES City (cid),     FOREIGN KEY (courses) REFERENCES Courses (course_id)   ); INSERT INTO personal(id,name,percentage,age,gender,city,courses) VALUES (1,"Aqib","45","13","M",1,1), (2,"Khadija","56","21","F",2,2), (3,"Salman Khan","62","20","M",1,1), (4,"Aqeela","47","18","F",3,1), (5,"Saqib","74","22","M",1,3), (6,"Abraham","64","21","M",2,2), (7,"Shahid","52","20","M",1,3); VIEW Examples /* Creat...
Read more

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 String Functions - II

Image
 How to work List of String Function-||: Code: 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,     courses INT NOT NULL,     PRIMARY KEY (id), FOREIGN KEY (city) REFERENCES City (cid),     FOREIGN KEY (courses) REFERENCES Courses (course_id)   ); INSERT INTO personal(id,name,percentage,age,gender,city,courses) VALUES (1,"Aqib","45","13","M",1,1), (2,"Khadija","56","21","F",2,2), (3,"Salman Khan","62","20","M",1,1), (4,"Aqeela","47","18","F",3,1), (5,"Saqib","74","22","M",1,3), (6,"Abraham","64","21","M",2,2), (7,"Shahid","52","20","M",1,3); Examples: SELECT SUBSTRING("Yahoo Baba...
Read more