CREATE TABLE vcampus.blackboard_topic_comment SELECT * FROM vcampus_2020.blackboard_topic_comment ...

Method1 For MySQL server version 5.7.6 or newer: ALTER USER 'jahid'@'localhost' IDENTIFIED BY '******'; Method2 For MySQL server version 5.7.5 or older: SET PASSWORD FOR 'jahid'@'hostname' = PASSWORD('*****'); OR SET PASSWORD FO...

1. Filter username start with a SELECT id, email, username, photo FROM users WHERE username LIKE 'a%'; 2. Filter username end with a SELECT id, email, username, photo FROM users WHERE username LIKE '%a'; 3. Filter username containing sh SELECT id, email, usern...

1. Add column example: ALTER TABLE users ADD COLUMN mobile VARCHAR(20) UNIQUE; ALTER TABLE users ADD COLUMN mobile VARCHAR(20) AFTER email UNIQUE; ALTER TABLE users ADD COLUMN mobile VARCHAR(20) BEFORE email UNIQUE; 2. Add multiple columns example: ALTER TABLE users ADD COLUMN `count` S...

delimiter // drop trigger if exists ad_question_bank// create trigger ad_question_bank after delete on mcq_bank_master for each row begin delete from mcq_bank_details where question_id=old.id; end;// delimiter ; It will be automatically executed when delete command is applied in parent tab...

For the latest version create database if not exists wdpf_40_alam; drop user if exists alam@localhost; flush privileges; create user alam@localhost identified with mysql_native_password by 'alam@123'; GRANT ALL ON wdpf_40_alam.* TO alam@localhost; flush privileges; For old versi...

Copy to existing table with same structure including related table

INSERT IGNORE INTO question_bank_certification SELECT * FROM mcq_bank_master where subject_id in(136); INSERT IGNORE INTO question_bank_certification_detials select * from mcq_bank_details where question_id in(select id...

First you have to create a tmp_field update item_uom_factor set factor=(select factor from item_uom_factor where item_id=5 and level=3) where level=2 and item_id=5 update item_uom_factor set factor=(select factor_tmp from item_uom_factor where item_id=5 and level=2) where level=3 and it...

SET @a = 0; UPDATE item_master set order_by=(@a:=@a+1); ...

In this tutorial, you will learn how to use MySQL cursor in stored procedures to iterate through a result set returned by a SELECT statement. What is Cursor? Cursor in MySQL is almost same as cursor in other database. As per Wikipedia following is cursor definition. "In computer science ...