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

Could we start a variable with number like $4name?

0 Answers  


What is good average session duration?

0 Answers  


List the different types of print functions available in php?

0 Answers  


Why do we use php?

0 Answers  


Does php pass arrays by reference?

0 Answers  






Write syntax to open a file in php?

0 Answers  


What is the purpose of destructor ?

2 Answers  


What is string function sql?

0 Answers  


How to convert numbers to strings in php?

0 Answers  


What is form validation in php?

0 Answers  


What is php artisan serve?

0 Answers  


What is the difference between php 5 and php 7?

0 Answers  


Categories