MySQL remove duplicate rows
Updated: 17th November 2023Tags: mysql sql
Tags: mysql sql
mysql str_replace
Updated: 4th February 2023Tags: mysql sql
UPDATE my_table SET column1 = REPLACE(column1, 'search string', 'replacement');
How to change auto_increment mysql
Updated: 9th January 2023Tags: sql mysql
ALTER TABLE my_table_name AUTO_INCREMENT = 777;
How to remove bin logs and turn it off
Updated: 19th December 2022Tags: mysql
How to free unused mysql space - OPTIMIZE tables
Updated: 12th December 2022Tags: mysql
How to find where MySQL data is being stored
Updated: 6th December 2022Tags: sql mysql
bash
mysql -e "show variables like 'datadir'"
mysql
show variables like 'datadir'
My programming tips after 10 years of programming
Updated: 28th April 2022Tags: php mysql
MySQL Fix login for phpmyadmin
Updated: 24th December 2019Tags: sql mysql
[Solved] MySQL ERROR 1231 (42000):Variable 'character_set_client' can't be set to the value of 'NULL'
Updated: 24th December 2019Tags: sql mysql
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
Troubleshoot
If you haven't acess to console or the previous doesn't work
set global max_allowed_packet=10000000000;
PHP Simple PDO class
Updated: 23th December 2019Tags: php mysql sql
How to be friend with mysql timestamp
Updated: 22th December 2019Tags: sql mysql