Multiple Insert Snippets

16 October, 2012   

MySQL code example to insert multiple records with one query

11 February, 2013   

File inputs can have an attribute of "multiple" which then allows multiple files to be selected in the file section dialog box.

A simple INSERT statement in MSSQL with the various types of values.

Take array and create multiple columns, define divisible by value ($divis) from total results then use modulus within the loop. This example shows multiple columns for unordered list items.

09 May, 2011   

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...

Maxscript UI & Graphical RPManager - Control multiple object properties with single object for

20 March, 2013   

ASP code example to block Multiple IP Addresses

13 October, 2013   

To create 'examples' database on your MySQL server you should run the following script

11 July, 2013   

It can be inserted into the newer table without any hassles over an incompatible number of fields.

16 January, 2013   

How to calculate age in years and months

12 January, 2014   

This is a pretty simple little snippet, but it help understanding how to use relational tables w/in PHP.

24 December, 2014   

Example shows here how to select from multiple mySQL tables.

This example code calculates the ratio between the X and Y columns of the RATIO table.

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.

11 July, 2013   

Help manage mysql database common task

How to Insert comments in the HTML source code

Create in dbgrid one column and insert the caption "RecNo" or other in title property. In dbgrid onDrawColumnCell event insert the following code:

07 September, 2014   

The "WITH CHECK OPTION" is used to indicate that Oracle will prevent any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.

30 December, 2010   

Class to back up entire databases and email them out, or individual tables

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.