databases
&
life
Newest
Categories
Random
Contact & Follow:
RSS
Email
GitHub
StackOverflow
LinkedIn
Twitter
Categories
> Mysql
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
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
CHAR
vs
VARCHAR
(and
VARCHAR2
)
mysqli_affected_rows gotcha