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.

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 Answers  

---

How to declare variable in mysql trigger?

1 Answers  

---

What is the difference between mysql_connect() and mysql_pconnect()?

7 Answers   TCS,

---

How to enable or disable a row of a table using MySQL in struts?

1 Answers  

---

What is view? How can you create and drop view in mysql?

1 Answers  

---

Explain the difference between primary key and candidate key in mysql?

1 Answers  

---

how to delete duplicate rows in sql server 2005?

2 Answers   EWIT, Reliance,

---

What is data directory in mysql?

1 Answers  

---

What is the difference between is null & is not null?

1 Answers  

---

How do I flush privileges in mysql?

1 Answers  

---

Can we store files in mysql?

1 Answers  

---

How to show table structure mysql?

1 Answers  

---