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

Answers were Sorted based on User's Feedback



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

Answer / vipul dalwala

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

Is This Answer Correct ?    11 Yes 3 No

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

Answer / sonal shah

we cannot insert into a table and select from the same table

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More PHP Interview Questions

What is $_ request in php?

0 Answers  


Explain about Functions in PHP?

1 Answers  


What is local variable in php?

0 Answers  


Is learning php easy?

0 Answers  


what does this symbol mean in php?

0 Answers  






How to remove duplicate values from php array?

0 Answers  


What are variables in research examples?

0 Answers  


how to detect a mobile device using php

0 Answers  


which function used to get the file name in php?

5 Answers  


Is age an interval or ratio?

0 Answers  


How to specify argument default values?

0 Answers  


What's diffrence between Get() and Post() Function

7 Answers  


Categories