| Other MySQL Interview Questions |
|| Asked @
|what is the advantage of left outer join?
|What is ACID?
|I have a table like this tblData (month int,Qty int)
and i am inserting three rows in this table
1.tblData Values (1,100)
2.tblData Values (2,200)
3.tblData Values (3,300)
The Result I want is the Running total of the field Qty
that is 1 100 100
2 200 300
3 300 600
What is the Query for that ?
|maximum database size of mysql database
|What happens if a table has one column defined as TIMESTAMP?
|how to display only 4 records from a table based on a
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
|Which one of the following is the correct way to select all
columns and all rows from "vtable"?
SELECT FROM vtable SELF JOIN vtable
SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = *
SELECT EVERYTHING FROM vtable
SELECT vtable.* WHERE vtable = vtable
SELECT * FROM vtable WHERE 1 = 1
|What is the maximum length of a table name, database name,
and fieldname in MySQL?
|what is the Dynamic management views? where can you use?
|How can increase the performance of MySQL select query?
|How do you start MySQL on Linux?
|For more MySQL Interview Questions Click Here |