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

Tell me how to set a page as a home page in a php based site?

926

Is PHP an open source software?

1063

What is "print" in php?

948

Tell me how to create a session? How to set a value in session? How to remove data from a session?

998

How to get number of days between two given dates using PHP?

900

How to redirect https to http url through .htaccess?

964

How to download and install php on windows?

1158

What is helper library?

928

What is echo and print in php?

964

How to set cookies?

1010

Explain about PHP filter and why it should be used?

948

How to copy a file?

1073

What is the use of the function 'imagetypes()'?

1022

Which php function will attach one file to another?

986

Is php an oop?

977