Answer / Anil Joshi

To create an auto-increment column in MySQL, you can specify the AUTO_INCREMENT attribute when creating the table. For example: CREATE TABLE table_name (id INT PRIMARY KEY AUTO_INCREMENT);

Is mysql relational database?

1 Answers  

---

What is the difference between char and varchar data types?

6 Answers  

---

What is the maximum number of columns per table?

1 Answers  

---

How to calculate the difference between two dates?

1 Answers  

---

What are the indexes in mysql?

1 Answers  

---

Which is better sqlite or mysql?

1 Answers  

---

How many rows we can insert in a mysql table?

1 Answers  

---

How many primary keys can be there in a table?

1 Answers  

---

How to add a new column to an existing table in mysql?

1 Answers  

---

Is mysql better than oracle?

1 Answers  

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1 Answers  

---

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

---