Question : I have db with innodb tables and use innodb_file_per_table After OPTIMIZE TABLE `db`.`table` of all tables the size […]
Tag: mariadb-10.6
How to convert a string year to a DATE
Question : STR_TO_DATE doesn’t work like I expect. STR_TO_DATE(‘2007’, ‘%Y’) STR_TO_DATE(‘2007’, ‘%y’) 2006-11-30 2019-11-30 10.6.7-MariaDB-1:10.6.7+maria~bullseye-log Answer : Use string operations […]
How to reduce the size of file in innodb_data_file_path (ibdata1) in mariadb without recreate db
Question : I have db with innodb tables and use innodb_file_per_table After OPTIMIZE TABLE `db`.`table` of all tables the size […]
mysql vs mariadb query [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
mysql vs mariadb query [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]