SQL INSERT INTO SELECT query for updating on same table with some modification I want to update this table
Table name: Student

Name      Department

Alex         CSE
Bob          EEE
Briyan       ME

by copying all rows with some modification like this table:
Table name: Student

Name      Department

Alex         CSE
Bob          EEE
Briyan       ME
Mr. Alex     SCIENCE(CSE)
Mr. Bob      SCIENCE(EEE)
Mr. Briyan   SCIENCE(ME)

What should be the SQL query ... can you help please?
I have tried this far:
INSERT INTO 
    Student (Name, Department)
SELECT Name,Department FROM Student;
So you're close you just need to add the data modifications you want to each field in your SELECT list like so:
INSERT INTO 
    Student (Name, Department)
SELECT CONCAT('Mr. ', Name), CONCAT('SCIENCE(', Department, ')') FROM Student;

You can use the CONCAT() function to concatenate strings in MySQL