Answer 1

The mysql execute method only takes 2 parameters. The query string as the first is required and the 2nd as a tuple is optional. Change the execution to;
cursor.execute(self.Sql, (email, passwrd))
and give that a try.

Answer 2

Your if else statement will always be false.
self.Sql is a string object
if self.Sql:
is basically asking if the string object exists, which it does with a value that is hard coded above. You then use not to negate the returned true to false.

Answer 3

You need to use fetchall() to try and get any rows from the table that match the query. If no rows exist then an empty string is returned. You can then do a check to see if the value returned is empty do x else do y.

Answer 4

fetchall() returns a list of tuples if at least 1 row is found from the query or an empty string if nothing is found. So you can use it like you can any other tuple within a list provided you use accordingly to the types of values returned.

Answer 5

Shashank Mishra I think you mean the EXISTS operator. I don't think it will work here as I believe it is used with 2 tables that have a relationship. I could be wrong though.

Answer 6

Sql provide a method called as EXTIES () ..

Answer 7

Its work bro on single table also