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

Tell me what should we do to be able to export data into an excel file?

0 Answers  


Explain mysql_error().

0 Answers  


What are super global variables in php?

0 Answers  


Tell me how is it possible to remove escape characters from a string?

0 Answers  


Where is my php ini file?

0 Answers  


what server connected

1 Answers   Wipro,


What is super () python?

0 Answers  


What is an anti csrf token?

0 Answers  


What is meant by public, private, protected, static and final scopes?

0 Answers  


What are php filters?

0 Answers  


What does nan stand for computer science?

0 Answers  


What are the advantages of stored procedures, triggers, indexes in php?

0 Answers  


Categories