从表中选择最后插入的数据

Question

First I tried to look for the answer on here(stackoverflow) as well as other sites like a microsoft forum, but couldn't find anything that answered my question. Or I just couldn't understand.

I'm working on a (school)project I got from a company, they gave me acces to their database. In here is a table with data from a sensor that registers stuff every once in a while.

Now my question is: I want to get the last data inserted into the table and show just one row (echo or print, I dont really mind how, I just want it to work and to understand it.)

The table looks as followed: Tablename= container_1

I want to show the last inserted data in COL 3. Is there a way to do this with the table the company provided me with?

Answer 1

Using phpmyadmin you can:

Select * from your_table order by col1 desc Limit 1;

This way you'll only have the last entry