The difference between a unique index and primary key in MySQL

http://www.xaprb.com/blog/2009/09/12/the-difference-between-a-unique-index-and-primary-key-in-mysql/

Dlaczego w MySQL’u nie stosować typu FLOAT

http://www.dobreprogramy.pl/slepciu/Dlaczego-w-MySQLu-nie-stosowac-typu-FLOAT,30401.html http://doctrine-dbal.readthedocs.org/en/latest/reference/types.html#decimal-types http://doctrine-orm.readthedocs.org/en/latest/reference/basic-mapping.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?

http://dev.mysql.com/doc/refman/5.6/en/replication-options-master.html#sysvar_auto_increment_increment 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’”

http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-debian-sys-maintlocalhost/

How to safely change MySQL innodb variable ‘innodb_log_file_size’?

http://dba.stackexchange.com/questions/1261/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?

http://blog.suszalski.pl/2011/03/jaka-wielkosc-innodbbufferpoolsize.html innodb_buffer_pool_size < 80% RAM, np: [mysqld] innodb_buffer_pool_size = 512M

MySQL Syntax Check

An online SQL Query Checker: http://www.piliapp.com/mysql-syntax-check/

Connection to a MS SQL Server from Symfony / Doctrine on Mac or Linux

http://dunglas.fr/2014/01/connection-to-a-ms-sql-server-from-symfony-doctrine-on-mac-or-linux/

Installing MySQL on OS X Mountain Lion

http://bookmarks.kraksoft.pl/tag/mac-os-x/ unset TMPDIR mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist