[Fix] Error Code: 1175 You are using safe update mode

4
Comments
[Fix] Error Code: 1175 You are using safe update mode

Explore an easy way to fix MySQL Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. You can either disable it permanently or turn it off before executing an update/delete statements and turn it back on after. SET SQL_SAFE_UPDATES=0; will fix it for you, but be careful, you are not protected against DELETE FROM table statement anymore.

Read further...

[Fixed] [ERROR] /usr/sbin/mysqld: unknown variable 'log_slow_verbosity=query_plan'

3
Comments

Error during installing MySQL server 5.5 on Ubuntu 14.04 I got following error when try to install mysql-server-5.5 on ubuntu 14.04: [ERROR] /usr/sbin/mysqld: unknown variable 'log_slow_verbosity=query_plan' After that I got start: Job failed to start To fix that: open /etc/mysql/my.cnf for edit and comment following string log_slow_verbosity=query_plan Then start installation from scratch: sudo apt-get install mysql-server

Read further...

CREATE DOMAIN в MySQL

0
Comments
CREATE DOMAIN в MySQL

Понадобилось заюзать домены (domain). Набрав SQL запрос типа "CREATE DOMAIN ..." я получил ошибку "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DOMAIN test as VARCHAR ...' at line 1". Так как мне нравился MySQL то начал гуглить на эту тему. И после нескольких часов поисков и прочтения "MySQL 5.1 Reference Manual" могу сказать одно - в MySQL версии 5.1 и ниже нет поддержки доменов. Так что теперь при...

Read further...