DATABASE | MYSQL | MYSQL INTERVIEW QUESTION AND ANSWERS 9 | HOW DO YOU FIND OUT WHICH AUTO INCREMENT WAS ASSIGNED ON THE LAST INSERT? | WHAT DOES TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DATA TYPE DO? | HOW MANY DRIVERS IN MYSQL? | HOW DO YOU RUN BATCH MODE IN MYSQL?

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