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 |
Do you know what is the difference between the include() and require() functions?
How to remove html tags from data in php?
What software is required for php?
What does namespace mean in php?
what method is used to get a user's IP address?
What the difference between the 'bitwise and' operator and the 'logical and' operator?
Can you use php and javascript together?
How to break a file path name into parts?
List some sorting functions in php?
what is php?
How can we encrypt the username and password using PHP?
3 Answers Rushmore Consultancy,
What are the advantages of indexes?