Mysql Interview Question and Answers

41. How do you find out which auto increment was assigned on the last insert?
  SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name.
42. What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
  On initialization places a zero in that column, on future updates puts the current value of the timestamp in.
43. How many drivers in Mysql?
 
    There are eleven drivers in MYSQL .Six of them from MySQL AB and five by MYSQL Communities.They are
  • PHP Driver
  • ODBC Driver
  • JDBC Driver
  • ado.net5.mxj
  • CAPI1PHP DRIVER
  • PERL DRIVER
  • PYTHON DRIVER
  • RUBY DRIVER
  • C WRAPPER
44. How do you run batch mode in mysql?
  mysql < batch-file >;
mysql < batch-file > mysql.out
12345678910 Page 9 of 10