mysql str_replace
Updated: 4th February 2023Tags: mysql sql
UPDATE my_table SET column1 = REPLACE(column1, 'search string', 'replacement');
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 acess 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;