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 |
Is php a framework?
What is isset in php?
Is php faster than python?
What are the advantages of triggers in php?
Tell us how can we display the output directly to the browser?
Distinguish between urlencode and urldecode?
Tell me how do I escape data before storing it into the database?
What is strlen php?
What is strcmp () in php?
how to use http headers inside php? Write the statement through which it can be added?
Is php easier than javascript?
What is the meaning of ‘escaping to php’?