Take a note all binary collation are case sensitive

select
leave_Type,
emp_Leave_From,
emp_Leave_To,
emp_Leave_Days
from leave_details
inner join leave_eli
on leave_details.leave_Type_Id=leave_eli.leave_Type_Id
inner join leave_cri
...

leave_cri:typs of leave allowd 4 an emp
leave_eli:all typ of leaves
leave_detail:details of leave taken by an emp

Does leave_cri has any emp id or some column to identify specific leaves are...

select leave_Type,emp_Leave_From,emp_Leave_To,emp_Leave_Days from leave_details inner join leave_eli on leave_details.leave_Type_Id=leave_eli.leave_Type_Id
inner join leave_cri on...

This is how i goes

Select
Student.stud_id,
Student.stud_name,
Max(subject.marks)
from Student, subject, stud_sub
where sum(marks)<
( Select Max(sum(marks)) from student, subject,...

If you can type all the column names you can get the default avatar_id(1)

Try this :

SELECT members.*,ifnull(avatar_id,1) FROM members
left outer join avatars
on...

Hey
in the query you r using
"where marks is less than max(sum(marks))"
This will be true for all the records as individual marks will be less than sum of them

Select
Student.stud_id, ...

select user from mysql.user where user=' ';

you should have access to mysql DB to execute the query

i didn't get u again.

from what i got
Mysql Administrator is used for administering Mysql server
and you want to put data in cvs file into mysql database

i guess both r 2 different things
...

what file upload size r u talking about??
R u talking about data packet size?

This will also work

select * from table1 where (depart COLLATE latin1_bin )=Upper(depart)

As the Error Says 3306 is being used by some other application

user netstat to find out which application is using it or try turnning off firewall if any

or else you have to use different port...