| Other MySQL Interview Questions |
|| Asked @
|What is Foreign Key?
What is the main difference between primary key and Foreign
How Foreign Key can be defined?
Is Foreign key is used to join two or more table?
|what is the advantage of stored procedures, triggers and
indexing in mysql
|What is the difference between char and varchar data types?
|How can we find the number of rows in a table using MySQL?
|Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?
|maximum size of a database in mysql?
|A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
|Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
|What is the difference Delete and Drop ?
|how we connect the data base in any programme
|how we can use more then one primary key in Single Table
|how we can find nth max salary from an employe table by
using my sql?
|For more MySQL Interview Questions Click Here |