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 are the advantages of php mysql?

1007

Explain about the data types in PHP?

1020

Which function is used in php to delete a file?

1066

How to write comment in php?

1221

Tell me what are the functions to be used to get the image's properties (size, width and height)?

1092

Tell me how can we define a variable accessible in functions of a php script?

989

How to open a file in php?

1125

what are the differences between php and perl

2088

What are php expressions?

1149

How to create an array in php?

1150

Which function is used to strip whitespace?

1013

Can we override static method in php?

1140

Why constructor is not overridden?

1056

What are the uses of implode() function?

1138

What are the steps for the payment gateway processing?

1056