a2zinterviews

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