Interview Questions And Answers
Q: - What is REPLCAE statement, and how do I use it?
The REPLACE statement is the same as using an INSERT INTO command. The syntax is pretty much the same. The difference between an INSERT statement and a REPLACE statement is that MySQL will delete the old record and replace it with the new values in a REPLACE statement, hence the name REPLACE.
Submitted By:-Uma Email-ID: - kumariuma44@yahoo.in
Q: - MySQL has a lot of neat functions. What if I need one that isn't there?
MySQL is so flexible that it allows you to create your own functions. These user-defined functions act the same way that MySQL's own intrinsic functions operate. It is also possible to recompile your functions into the application so that you will always have them, no matter how many times you install.
Submitted By:-Uma Email-ID: - kumariuma44@yahoo.in
Q: - Do all unique keys have to be primary keys?
No. MySQL permits only one primary key per table, but there may be a number of unique keys. Both unique keys and primary keys can speed up the selecting of data with a WHERE clause, but a column should be chosen as the primary key if this is the column by which you want to join the table with other tables.
Submitted By:-Uma Email-ID: -kumariuma44@yahoo.in
 |
 |