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
Answer / vipul dalwala
INSERT INTO table_name SELECT * FROM table_name WHERE
column_name = 'select condition';
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / sonal shah
we cannot insert into a table and select from the same table
| Is This Answer Correct ? | 2 Yes | 3 No |
What are the different ways to login to a remote server? Explain the me, advantages and disadvantages?
Draw the architecture of Zend engine?
What is a helper function?
Explain Traits in PHP?
Is it possible to protect special characters in a query string?
How do you achieve page caching in PHP?
What distinguishes php from something like client side java script?
What is local variable in php?
How can i execute PHP File using Command Line?
How to make multilanguage site in php? (like english,tamil)
What type of headers have to be added in the mail function to attach a file?
What should we do to be able to export data into an excel file?