PostgreSQL: How to Disable or Enable Foreign Key Constraint of a Table ALTER TABLE table_name DISABLE TRIGGER ALL; INSERT INTO table_name VALUES (1,6,50,60,90); ALTER TABLE table_name ENABLE TRIGGER ALL;

UUID Primary Keys in PostgreSQL psql 9.5: gen_random_uuid() not working? SELECT gen_random_uuid() produces output: ERROR: function gen_random_uuid() does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. you can check if the functions are defined using: select * from pg_proc where proname like ‘gen_random_%’; ...

The difference between a unique index and primary key in MySQL

Dlaczego w MySQL’u nie stosować typu FLOAT,30401.html

Problem during MySql update from 5.5 to 5.6 version

When you encountered the error message: mysql-server-5.6 : Depends: mysql-client-5.6 (>= 5.6.19-1~dotdeb.1) but it is not going to be installed during MySql update from 5.5 to 5.6 version, you should do: sudo apt-get install mysql-common=5.6.19-1~dotdeb.1 You can also check all available version with: sudo apt-cache showpkg mysql-common

How to set auto increment jumps by more than the number of rows inserted? auto_increment_increment and auto_increment_offset are intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns.

MySQL: “Access denied for user ‘debian-sys-maint’@’localhost’”

How to safely change MySQL innodb variable ‘innodb_log_file_size’? innodb_log_file_size = 25% * innodb_buffer_pool_size, np: [mysqld] innodb_log_file_size = 64M

Jaka wielkość innodb_buffer_pool_size będzie optymalna? innodb_buffer_pool_size < 80% RAM, np: [mysqld] innodb_buffer_pool_size = 512M

MySQL Syntax Check

An online SQL Query Checker: