Asset Update Snippets


02 January, 2012   

The UPDATE statement is used to update existing records in a table

26 January, 2012   

A simple example template of an Asset Update XML

14 May, 2011   

This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.

29 July, 2013   

Update random dates in MYSQL table

Example code to update or convert the field to UPPERCASE.

22 December, 2012   

How to update random dates in MYSQL table

28 November, 2013   

Edit database using vb + access

11 July, 2013   

Help manage mysql database common task

MS SQL triggers for automatic Create and LastModified Dates

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

How to dynamically update your Snippets

05 October, 2016   

This code accumulates 100 units of part number 9999 from various storage bins

24 July, 2013   

An example of how to use the mysql_real_escape_string

23 November, 2013   

You can search and replace fields by below query in MySQL Database

16 February, 2011   

HTML5 Article Structure with hNews

HTML5 code for Article Structure with hNews

29 December, 2012   

Example MySql code to append Data to Field in MySql

Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.

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.

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )