How do you get the number of rows affected by query?

Which is not a MySQL Operator?a. Between..and..,b. Like,c. IN,d. Is NULL

How many triggers can be created for each tables ?

What will be returned? SELECT column_name FROM table1 LEFT JOIN table2 ON table1.column_name=table2.column_name;

Which SQL function returns the current date?

Considering table foo has been created with:

create table foo (id int primary key auto_increment, name varchar(100));

Is the following query syntactically valid?

delete from foo where id = id-1;

For GRANT statement. which is used to grant all permissions to a user?

Which constructs for flow control are supported by MySQL?

Which are valid MySQL DATETIME and TIMESTAMP value formats?

Which statements regarding the TRUNCATE TABLE statement are correct in MySOL 5.6?

Which is NOT a constraint of the INSERT DELAYED statement?