Give the syntax of REVOKE commands?
Answer / rajan vardawaj
The generic syntax for revoke is as following REVOKE
[rights] on [database] FROM [username@hostname] Now rights
can be: a) ALL privilages b) Combination of CREATE, DROP,
SELECT, INSERT, UPDATE and DELETE etc. We can grant rights
on all databse by usingh *.* or some specific database by
database.* or a specific table by database.table_name.
| Is This Answer Correct ? | 7 Yes | 0 No |
What is root password?
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
Is Mysql query is case sensitive?
What is mysql_query?
What does mysql_query return?
Explain the difference between delete and truncate.
How many rows we can insert in a mysql table?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is mysql root?
How can we store binary data in mysql?
SELECT country,city FROM customers GROUP BY country ORDER BY city DESC
Why is mysql used?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)