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 php artisan tinker?

0 Answers  


how to run PHP in command line?

8 Answers   InfoShore, Ramp Green, Xtreeme,


What does pear stand for?

0 Answers  


How can we create a database using PHP and mysql?

4 Answers   Rushmore Consultancy,


How to get total number of elements used in array?

1 Answers  


What is in php 7?

0 Answers  


Should I use mysqli or pdo?

0 Answers  


Will a comparison of an integer 12 and a string "13" work in php?

0 Answers  


What is difference between web service and api?

0 Answers  


what is CURL?

0 Answers  


What is query string php?

0 Answers  


Explain the three different kinds of Arrays?

0 Answers  


Categories