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.

How to see table's field formats or description of table .

0 Answers  

---

What are the types of database engines available in mysql?

0 Answers  

---

What is the datatype for password in mysql?

0 Answers  

---

What is meant by mysqli?

0 Answers  

---

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 Answers  

---

What is SERIAL data type in MySQL?

3 Answers   Aspire,

---

List some mysql advantages and disadvantages?

0 Answers  

---

What are the functions of commit and rollback statements?

0 Answers  

---

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

---

How do I download mysql on my laptop?

0 Answers  

---

What data type is money?

0 Answers  

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  

---