SQL select latest row from table
Updated: 22th December 2019Tags: sql
SELECT * FROM my_table ORDER BY id DESC LIMIT 1;
SELECT * FROM my_table ORDER BY id DESC LIMIT 1;
SELECT MAX(id) FROM my_table;
$randomRow = DB::table('table')
->inRandomOrder()
->first();
$randomId = DB::table('table')
->inRandomOrder()
->value('id');
SELECT * FROM my_table ORDER BY RAND() LIMIT 1;
After installing laravel you MUST change some folder permissions.
sudo chmod 755 -R laravel_app
sudo chmod -R o+w laravel_app/storage
sudo chmod -R o+w laravel_app/bootstrap/cache