Rubrika: MySQL
mysql.service – Start request repeated too quickly
Error: root@Skeeve:/var/log# systemctl start mysql.service Job for mysql.service failed because the control process exited with error code. See „systemctl status mysql.service“ and „journalctl -xe“ for details. root@Skeeve:/var/log# systemctl status mysql.service ● mysql.service – MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled) Active: failed (Result: exit-code) since Sun 2021-05-30…
mysql – update – Update from select – example
UPDATE rs_users as a INNER JOIN (SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key = ‚telefon‘) as b ON a.user_id = b.user_id SET a.phone = b.meta_value
mysql – Disable ONLY_FULL_GROUP_BY
/etc/mysql/mysql.conf.d/ vi mysqld.cnf [mysqld] sql_mode = „ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION“ /etc/init.d/mysql restart