1) Copy One column data from a table to other

As Sub Query is slow to see your query is running or not use following:

SHOW PROCESSLIST;

To Kill any process use following:

Syntax:

Example:

 

2) Insert records into table by selecting data from same table

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Post Navigation