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 is difference between session_unset and session_destroy?
find highest salary
what is the difference between mysql_fetch_array() and mysql_fetch_row()?
Write the statements that are used to connect php with mysql
Is php still used?
"mysql_fetch_row — Get a result row as an enumerated array",this sentence comes from the PHP offical manual.However ,i can not understand the words "enumerated array".I need some help.Thanks a lot to everyone that reply.
What is active record in php?
What is the use of php and mysql?
Does php support overloading?
Write a program to find no of days between two dates in php?
What is traits? How it is used in php?
Which is the dependent variable?