Bug #64813 commands working without any error even though not supplied value in where claus
Submitted: 30 Mar 2012 10:37 Modified: 30 Mar 2012 16:08
Reporter: SP Chowdary Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Websites: bugs.mysql.com Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[30 Mar 2012 10:37] SP Chowdary
Description:
i have tried with delete ,select query to do the changes in the database.

select * from employee where eno;
delete from employee where eno;

In the above queries even though i have not supplied the eno values it is showing QUERY OK, and it is effecting all the rows.

If i use the above query to delete the specified row and there i have not supplied value, but it is deleting all the rows. So it is a problem i think since it is deleting all the rows which is undesirable.

Another one is  in the sql editor if we want to clear the screen no command is working.. tried with clear;
/c;
commands but no response.....

How to repeat:
select * from employee where eno;
delete from employee where eno;

problem with the queries
[30 Mar 2012 16:08] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.