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

 

Cake PHP Web Development Tips And Tricks

Cake PHP Web Development Tips And Tricks

Inserting Foreign Language Characters in MySQL and Enable utf8 encoding with in Cakephp

Step 1: GO to database.php and add following and save it.

Step 2: Go to you desired table and Choose utf8 character set and utf8_general_ci collation for any particular filed for which you want to show unicode in hindi language or any other

Example :

That’s it.

Enjoy your character encoding :)