Snipplr

(SQL) Manual activation of a module in Joomla! - iroybot

Fri, 10 Feb 2012 11:42:10 GMT

in order to avoid the .zip madness when creating a new module, you can make it available in the backend by firing a simple SQL in your DB. (mod_media is the name of the folder that holds it)

(SQL) Query to find Parameters and Value Sets associated with a Concurrent Program - theonlyalterego

Sat, 21 Jan 2012 07:38:14 GMT

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

(SQL) Sql Date Difference - jsturtevant

Sat, 07 Jan 2012 01:29:19 GMT

Can use second, Minute and many other from the url above

(SQL) Where clause to select multiple rows of unique values - the_construct

Thu, 05 Jan 2012 21:42:32 GMT

Where clause to select multiple rows of unique values

(Django) Clean up expired django.contrib.session\'s in a huge MySQL InnoDB table - magicrebirth

Fri, 30 Dec 2011 23:12:12 GMT

While django provides the django_admin.py cleanup script, if sessions get out of control sometimes you have to go lower level to get everything cleaned up. If the problem gets out of hand and you hit the resource limits of the machine, it is very difficult to get anything done in the database. Attached is SQL code which was used to cleanup 27GB of expired session data in 3h. Run it like this to make sure it runs to completion: `nohup mysql --user=username --password=password --host=hostname database < delete_expired_sessions.sql` nohup causes the script to run detached from a terminal, so if your session gets disconnected it will keep running. p.s. An alternative approach is to launch this command from the shell: DELETE FROM django_session WHERE expire_date < NOW(); or DELETE FROM django_session WHERE expire_date < "2011-12-10 00:00:00";

(SQL) Oracle SQL - get a list of most recent user logins - theonlyalterego

Fri, 23 Dec 2011 05:53:20 GMT

Query to find the most recent logins for a particular user ( find 1 years worth )

(Other) insert into (backup table) - BrentS

Tue, 20 Dec 2011 04:55:02 GMT

(SQL) Auto Incremementing Id for Insert in T-SQL table - ezerick

Tue, 20 Dec 2011 04:28:54 GMT

This code allows you to create an ID field value for inserts into a table that does not auto increment itself

(SQL) Find duplicate entries - Neven

Mon, 14 Nov 2011 23:07:17 GMT

Searches for duplicate entries in the DataBase table

(SQL) Convert integer to date using SQL in iSeries DB2 - wnasich

Sat, 12 Nov 2011 02:21:22 GMT

intfield has this format: YYYYMMDD

(SQL) Find rows with last date of month - danfsmith

Wed, 09 Nov 2011 01:27:51 GMT

(SQL) TSQL COVERING INDEX - amos24c

Tue, 01 Nov 2011 10:54:41 GMT

(SQL) Oracle - Find which users have FND Diagnostic profile value set - theonlyalterego

Wed, 26 Oct 2011 06:40:55 GMT

A slight adaptation on the sql in the Oracle Forum

(MySQL) US & CANADA Cities Database - frederichoule

Sat, 22 Oct 2011 12:36:31 GMT

(PHP) Codeigniter: show SQL query from Active Record - telltec

Sat, 15 Oct 2011 01:00:48 GMT

(SQL) Connect string for Oracle with sqlplus - blackthorne

Tue, 11 Oct 2011 01:26:15 GMT

(PHP) Database php class - claudiowebdesign

Wed, 05 Oct 2011 09:31:06 GMT

That's something quick. A basic php class to manage properly a database. Thanks to magic methods opening a database is almost automatic.

(SQL) Sintaxis básica/habitual SQL para consulta tipo DELETE - alberomo

Thu, 15 Sep 2011 00:58:28 GMT

Sintáxis y clausulas más habituales para consulas SQL con cláusula DELETE que elimina uno o varios registros de la tabla que se especifica.

(SQL) Sintaxis básica/habitual SQL para consulta tipo UPDATE - alberomo

Thu, 15 Sep 2011 00:54:46 GMT

Sintáxis y clausulas más habituales para consulas SQL con cláusula UPDATE que actualiza/modifica uno o varios registros de la tabla que se especifica.

(SQL) Sintaxis básica/habitual SQL para consulta tipo INSERT INTO - alberomo

Thu, 15 Sep 2011 00:41:05 GMT

Sintáxis y clausulas más habituales para consulas SQL con cláusula INSERT INTO que añade un nuevo registro a la tabla que se especifica.