how to select single row from table and insert into same
table as a new record by using a single sql query.

Answer Posted / vipul dalwala

INSERT INTO table_name SELECT * FROM table_name WHERE
column_name = 'select condition';

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

armstrong number by using php while number is given by the keyboard.?

1699


Define soundex()?

515


How to write in a file in php?

537


Is php used in 2019?

537


What is php and why we use it?

496






"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.

1532


How check submit button is clicked in php?

520


What is the use of trim function in php?

527


Tell me what is the use of "enctype" attribute in a html form?

550


what is difference between PHP4 , PHP5

1897


So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?

554


What is x+ mode in fopen() used for?

559


Is it worth learning php in 2019?

528


Can we run php in apache tomcat?

522


What are arguments in php?

563