Thursday, 27 December 2012

php coding of move row between tables

INSERT INTO table2 (column_name1, column_name2) SELECT column_name1, column_name2 FROM table 1 WHERE <insert_where_clause_here>
DELETE FROM table1 WHERE <your_where_clause>

PHP Coding for copy one Table to Another Table

CREATE TABLE NEW_TABLE_NAME AS (SELECT * FROM  OLD_TABLE_NAME )