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

What is warning – “cannot modify header information – headers already sent”?

1026

What is parent __construct ();?

970

How to update memcached when you make changes to php?

922

How you can update memcached when you make changes to php?

1035

What is strlen function in php?

980

What is get method in java?

1013

What are the new features available in php 7?

948

What is string function sql?

941

What is echo in html?

847

What is preg_match?

910

Which is the best php framework for a beginner?

947

What is a persistence cookie?

895

How can i execute PHP File using Command Line?

934

What is use of header() function in php?

994

What is ci framework in php?

952