Please answer these MySQL questions important on my project.

Asked By Trevor Weiss 20 points N/A Posted on - 02/25/2013

Hello there! I will just ask some MySQL questions as I don’t understand them. I need these in my current project. Here they are:

1. What is the use of InnoDB?

2. How will I display only the last record in the same table with equal preference?

3. What is the correct command of counting the number of records in a table?

Thank you for those who will answer!

• Status: Open
• Question Views: 572
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Lerbert Hink 0 points N/A #139320

Please answer these MySQL questions important on my project.

Hi Trevor,

         The use of InnoDB is as follows:

a.       Row- level locking

b.      Foreign key constraints

c.       Performance

d.      Concurrency

e.      Reliability

f.        Data Security

To answer your 2nd question, I am making the assumption that the last record in the table has some attribute as largest. For example: Employee Table having employee number as the primary key and other employee details.

Select * from Employee where employee number = (Select max(employee number) from Employee)

        The answer to your 3rd question would be:

        Select count(*) from table

About Lerbert Hink

Questions
4

Answers
13

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 03/05/2013
• Question Category: MySQL Server