INSERT INTO table_name SELECT * FROM table_name WHERE column

how to select single row from table and insert into same
table as a new record by using a single sql query.

Question Posted / vipul dalwala

Answer Posted / vipul dalwala

INSERT INTO table_name SELECT * FROM table_name WHERE
column_name = 'select condition';

Is This Answer Correct ?

11 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can you create a session in php?

992

What does a delimiter do in mysql?

992

Which one is best framework for php?

919

Explain what does $_files means?

1023

How do you clear environment variables?

879

How can we display information of a variable and readable by human with php?

1017

What is default session time in php?

915

How is it possible to parse a configuration file?

906

What is the difference between mysql_fetch_array() and mysql_fetch_assoc()?

995

What websites use php?

918

What is lazy loading in php?

912

What are sql functions?

899

Write a program in php to reverse a number?

946

Whether php supports microsoft sql server?

975

Tell me what is the actually used php version?

971