FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

MYSQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
46. What command do you use to show the current version number of MYSQL?
  SELECT VERSION();
Your Name Your Email-ID
Your Answer
 
47. What is the different between NOW() and CURRENT_DATE()?
  NOW () command shows current year,month,date with hours,minutes and seconds.
CURRENT_DATE() shows current year,month and date only.
Your Name Your Email-ID
Your Answer
 
48. How to update auto increment value for 100?
  ALTER TABLE tbl_name AUTO_INCREMENT = 100;
Your Name Your Email-ID
Your Answer
 
49. What command do you use if the table is exist?
  CHECK TABLE table_name;
Your Name Your Email-ID
Your Answer
 
50. What is the Difference Between MySQL and MySQL AB?
  The name “MySQL” is sometimes used to refer to the MySQL database management system and sometimes to the company behind it. The company is more properly known as MySQL AB. MySQL is the DBMS product that MySQL AB owns, develops, and sells-that is, the database server software called “MySQL” and related products, such as client programs for communicating with the server and programming interfaces for developing new clients.
As a side note, the “AB” part of the company name is the acronym for the Swedish “aktiebolag,” or “stock company.” Thus, the name translates to “MySQL Inc.” In fact, MySQL Inc. and MySQL GmbH are examples of MySQL AB subsidiaries.
Your Name Your Email-ID
Your Answer