| Other MySQL Interview Questions |
|| Asked @
Iím doing one Project in vb.net 2008 using mysql .In that
Project have the following Issues..
1.if one Employee getting Salary 1.2 lacs / annum means ..
After he getting 1st month Salary i want to show remaining
11 month salary.. How can i Create Trigger for this Problem
& How can i use it..
|How can we find the number of rows in a table using MySQL?
|what if you really want to store the timestamp data, such
as the publication date of the article?
|What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
|mazimum size of a database in mysql? when we create a table
then how many tables actually created? write there name?
|What is the use of indexing table?
|What does myisamchk do?
|how to declare unique key in creating a table..?
|what is the main difference between myisam and innodb
|Query to select passwords from a table having a column
"Password" Whose length is b/w 8 &15 and having 'A' as the
first character in the password irrespective of case.
|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 ?
|What is the difference between mysql_fetch_array and
|For more MySQL Interview Questions Click Here |