What is append query?



What is append query?..

Answer / Ram Murti

An Append Query in MySQL is used to insert new records at the end of a table. It's an efficient way to add data without affecting existing records, but it can only be done if the table has no primary key or has an auto-increment primary key.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the use of mysqli_query?

1 Answers  


What is the maximum connection pool size?

1 Answers  


How to concatenate two character strings?

1 Answers  


Is mysql good for big data?

1 Answers  


What is the difference between truncate and delete?

1 Answers   DELL,


What is ISAM?

1 Answers  


Is mysql an oracle product?

1 Answers  


at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  


What is a storage engine? What are the differences between innodb and myisam engines?

1 Answers  


What is root password?

1 Answers  


What is bdb (berkeleydb)?

1 Answers  


Define REGEXP?

1 Answers  


Categories