Create Table Snippets


24 June, 2015   

Create a table with the results from a SELECT statement.

Here are the procedure example to create table. you can call this procedure by command like : call myProc();

Here are the example to create temporary table in a procedure .

16 March, 2014   

How to create mysql table using php. The php script as follows as:

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...

13 October, 2013   

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

MS SQL triggers for automatic Create and LastModified Dates

14 February, 2011   

Build a Calendar Table

How to get number of rows in tables of database

16 January, 2013   

How to calculate age in years and months

29 April, 2013   

Saving the IP as Int we save a lot of space and permit do beautiful selects

23 November, 2013   

Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.

Using a stored procedure as the source in an OLE_DB Source for SSIS, the package can’t detect the output of the stored proc.

27 March, 2013   

CSS code for table-layout property using an example code in html page.

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

21 December, 2013   

The following table has a caption. The first row and the first column contain table header cells only; other cells are data cells.

In this example we will select everything in our table "example" and put it into a nicely formatted HTML table.

14 August, 2014   

Easy way to copy the contents of one table to another table.

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.