MySQL DROP & TRUNCATE

 How to Work Drop & Truncate in MySql:

Syntax:


DROP & TRUNCATE

TRUNCATE TABLE courses;

DROP TABLE courses;


Comments

Post a Comment

Popular posts from this blog

MySQL UNION & UNION ALL

Image
 How to work UNION & UNION ALL: Example: 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); create table "city" and in...
Read more

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 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