Calendar Table Snippets

PHP & Mysql based code to Print table with client-side sorting function.

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

18 December, 2014   

Example code for locking table. when a user modifies data through a transaction, that data is locked by that transaction until the transaction is committed or rolled back.

10 September, 2011   

Example code showing how to add a primary constraint. This Oracle constraint is used to identify the primary key for a table. A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. This...

How to get number of rows in tables of database

08 February, 2011   

Empty Table Markup

26 December, 2011   

Example PHP code to navigate calender in HTML pages

23 October, 2012   

MySQL code example for sorting data in a GRID

26 April, 2012   

JavaScript code example for Table Row Highlight

26 April, 2012   

Code for Table Row Highlight By JavaScript

If we wanted to select only certain entries of our table, then we would use the WHERE clause .

29 July, 2013   

Selecting a Random Row from Table in MySQL

09 October, 2011   

This code shows how to backup a table to a CSV file.

23 February, 2012   

XML Code to display XML data in an HTML table

12 January, 2012   

Example for Dumping a database to HTML tables

17 December, 2011   

In a table, some of the columns may contain duplicate values. Sometimes you will need to list only the different (distinct) values in a table. The DISTINCT keyword can be used to return only distinct (different) values.

22 December, 2012   

How to update random dates in MYSQL table

12 July, 2012   

PHP MySQL code to select row randomly fast

22 February, 2018   

MySQL Code Snippets to Export Table to File CSV

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