Answer / Md Akram

No, MySQL does not automatically create an index on foreign key columns. If you want to improve performance when querying data that involves foreign key relationships, you should manually create an index on the foreign key column using the `CREATE INDEX` command.

What is a transaction? Describe mysql transaction properties.

1 Answers  

---

How do I start mysql in mysql workbench?

1 Answers  

---

Why do we use pragma autonomous transaction?

1 Answers  

---

Is there a free version of mysql?

1 Answers  

---

maximum database size of mysql database

2 Answers  

---

How we can see all indexes defined for a table in mysql?

1 Answers  

---

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

1 Answers  

---

What storage engines are used in MySQL?

1 Answers  

---

How do I enable mysqli extension?

1 Answers  

---

What is mysql data directory?

1 Answers  

---

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 Answers  

---

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

---