[postgresql only] Fix users table’ autoincrement
select setval('users_id_seq', coalesce(
(select max(id)+1 from users), 1), false)
[postgresql only] Manually set next autoincrement id of users table to 100:
setval('users_id_seq', 100)
UPDATE my_table SET column1 = REPLACE(column1, 'search string', 'replacement');
ALTER TABLE my_table_name AUTO_INCREMENT = 777;
bash
mysql -e "show variables like 'datadir'"
mysql
show variables like 'datadir'
If you try to import dumped file, and there is such an error, try using mysql console with options and then import sql file
mysql -u root -p --max_allowed_packet=6400M
If you haven’t access to console or the previous doesn’t work
set global max_allowed_packet=10000000000;
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;