Kein Bild

mysql

Dezember 8, 2017 stefan 0

How to get size of whole mysql-db? SELECT Round(Sum(data_length + index_length) / 1024 / 1024, 1) „size“ FROM information_schema.tables GROUP BY „size“;

Kein Bild

mysql-fuzzy-logic

Oktober 4, 2017 stefan 0

If you want to search words that are not spelled correctly you can use mysql’s buildin SOUNDEX function: SELECT * FROM po_images WHERE SOUNDEX(`keyword`) LIKE CONCAT( ‚%‘,SUBSTRING(SOUNDEX(‚wronk spellet […]