databases
&
life
Newest
Categories
Random
Contact & Follow:
RSS
Email
GitHub
StackOverflow
LinkedIn
Twitter
Categories
> MySQL
CHAR
vs
VARCHAR
(and
VARCHAR2
)
Always use MySQL’s ENUM datatype instead of VARCHAR
Automatic reconnect from Hibernate to MySQL
Constraint name visibility on MySQL and PostgreSQL
Difference between row-level locking algorithms on Oracle and MySQL InnoDB
How to install Percona MySQL 5.6 on Ubuntu 14.04 LTS from a script (i.e. without an interactive prompt for the mysql root password)
If you’re using MySQL, always choose InnoDB over MyISAM
mysqli_affected_rows gotcha
PostgreSQL vs MySQL “update” difference
The failings of MySQL’s
curtime
function
Warning: MySQL
LOCK TABLES
command does an implicit commit
XML in the database