Update Field Snippets


Example code to update or convert the field to UPPERCASE.

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.

02 January, 2012   

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

29 December, 2012   

Example MySql code to append Data to Field in MySql

29 July, 2013   

Update random dates in MYSQL table

21 September, 2011   

Allows you to add a string to end or start of a field to use when comparing or selecting data. The second argument is added to the end of the first

30 April, 2016   

So better not to do, because the invisible fields are not needed for the binding form of validation of input data, etc.

MySQL code to find all duplicates in a database column(s)n.

15 February, 2015   

Move field position while still retaining its content.

22 December, 2012   

How to update random dates in MYSQL table

14 September, 2013   

An example for MySQL Results To Array

Mysql code example to SELECT based on a field that can have a NULL value.

28 November, 2013   

Edit database using vb + access

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

11 July, 2013   

Help manage mysql database common task

MS SQL triggers for automatic Create and LastModified Dates

30 March, 2013   

The characters in a password field are masked (shown as asterisks or circles).

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

15 June, 2014   

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

When using forms within your web site, there may be times when you will want to include an example of what you'd like your visitors to fill in your form field. Although you could place some default text within your form field, your users would need to delete the default text in order to type in their own information.