sir i want to create new table from another table (only structure of table) and then record of table.
You can use this syntax,
CREATE TABLE new_table AS (SELECT * FROM old_table);Visit this link for more syntax:
http://www.techonthenet.com/sql/tables/create_table2.php