Subscribe
Twitter Updates
- RT @firefox: A new update for Firefox is here. This release makes updating easier and includes a bunch of developer goodies: http://t.co ... 3 weeks ago
- today's worklog: git log --committer=cristianrd --since=1.day 1 month ago
- Beware of deceptive in-app advertising bit.ly/IENvRS 1 month ago
- RT @phoronix: Adobe Issues Final Linux Flash Player Release: Adobe released the official Flash Player 11.2 for Linux release t... http:/ ... 1 month ago
- James Justice Shuts Down the College Dunk Contest: youtu.be/BS737iP9AzY via @youtube 1 month ago
Category Archives: MySQL
Display random posts in WordPress
WordPress posts may be randomly displayed using the “Get random results from a MySql table” tip placed in a simple plugin. What this plugin does is to simply ad the “RAND()” value to “ORDER BY” clause in the sql query which retrieves the WordPress posts.Continue reading
Get random results from a MySql table
It is possible to retrieve random results from a MySql table using the RAND() mathematical function. In order to get the random results the RAND() function needs to be used in the ORDER BY clause.Continue reading
Insert value “0″ for primary keys with auto increment in MySQL
In order to insert value 0 in a field that is set as primary key for a MySQL table you need to execute the following query prior to any insert query: SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;Continue reading
Disable foreign key checks in MySQL
Disabling foreign key checks in MySQL is usefull when you are dealing with tables that use foreign keys (InnoDB engine).Continue reading
