Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

MySQL: last row

0
0
 
0
Language: SQL
Posted by: Fabian Constien
Added: Nov 21, 2017 5:54 AM
Views: 2366
Tags: no tags
  1. # imho bessere Performance als via ORDER und LIMIT
  2. SELECT * FROM `table` WHERE `id`=(SELECT MAX(`id`) FROM `table`);

1 comment

Guillermo Leonardo 2 years ago
Reply
or:
SELECT * FROM `table` ORDER BY Id desc limit 1;

Write a comment

To post comments, please log in or register.