Snipplr

(Java) Connecting to Oracle using Java JDBC - roizaig

Sat, 20 Apr 2013 00:03:13 GMT

Connecting to Oracle using Java JDBC

(MySQL) La fonction COALESCE de MySQL permet de renvoyer une valeur par défaut si la valeur null est renvoyée initialement. - pruntrut

Tue, 29 Jan 2013 20:53:55 GMT

Le fonction COALESCE de MySQL permet de renvoyer une valeur par défaut si la valeur null est renvoyée initialement.

(MySQL) [MySQL] Add condition to Virutal Fields - tucq88

Thu, 10 Jan 2013 13:50:19 GMT

By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT

(Python) batch accounts import into discuz with python - dylanninin

Tue, 04 Dec 2012 22:23:05 GMT

batch accounts import into discuz with python

(PHP) JSONP Public API with jQuery getJSON (callback) (MySql) - halk

Fri, 16 Nov 2012 09:08:46 GMT

This is a public jsonp api. I use it with jQuery Like This: $.getJSON("http://yourdomain/yourpath/jsonp_api.php?method=getSchema¶ms=your_db_name&jsoncallback=?", function(data){ //DO SOMETHING WITH THE DATA HERE } );

(MySQL) What MySQL Table Has What Column - philsown

Fri, 16 Nov 2012 00:50:08 GMT

How to find a given column in a given database in MySQL

(MySQL) create new database - claudiodev

Mon, 22 Oct 2012 21:45:32 GMT

Create a new database and its respective user with all privileges

(PHP) Simple PDO Insert method - BergBenji

Mon, 22 Oct 2012 21:28:59 GMT

Simple method to insert data to sql

(PHP) [CakePHP] Update field with current field data - tucq88

Mon, 22 Oct 2012 15:05:57 GMT

Update current field data.

(MySQL) Remap values inside a MYSQL query using CASE...WHEN syntax - ginoplusio

Sat, 20 Oct 2012 08:14:57 GMT

How to remap a value to another inside a mysql query select.

(PHP) PDO Insert array function - rickygri

Wed, 10 Oct 2012 22:33:16 GMT

PDO-format insert array function

(MySQL) MySQL - Simulate MySQL Queries - satie83

Thu, 20 Sep 2012 20:29:21 GMT

You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).

(Python) MySQL Pipeline - scrapy

Sat, 01 Sep 2012 07:14:54 GMT

(Bash) Setting Up Root User mysql - inky76

Mon, 27 Aug 2012 12:51:38 GMT

(PHP) Database Connection - evinweissenberg

Sat, 18 Aug 2012 07:31:41 GMT

Allows you to connect to different datasources. Very common to use something like this for development,staging and production deployments.

(MySQL) Pivot table Schedule - cahyadsn

Wed, 25 Jul 2012 13:43:46 GMT

You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.

(MySQL) Age in Years for Given Birthdate - cahyadsn

Wed, 25 Jul 2012 13:31:22 GMT

Given a birthdate in @dob, here are two simple formulae for age in years : (the second formulae is for age in years to two decimal places, ignoring day of month)

(PHP) MySQL INSERT Query Generator w/ Strings - lemcoe9

Fri, 13 Jul 2012 02:39:08 GMT

Takes your table name and key=>value array of values and returns the text for inserting into a MySQL database. Automatically surrounds strings with single quotes.

(SQL) Backup Export MySQL Database using mysqldump and compress gzip it - MohamedAlaa

Thu, 05 Jul 2012 01:44:58 GMT

Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------

(SQL) Import MySQL Dumpfile, SQL Datafile Into My Database - MohamedAlaa

Thu, 05 Jul 2012 01:35:13 GMT

Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql