Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax array c forms

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged table

« Prev 1 Next »

SQL mysql clone table with structure and indexes

clone table with structure and indexes

table

0 2904 posted 10 years ago by ktrout

SQL Table creating sql for a typical shopping cart

Confirm the sql script file is encoded with `UTF-8`

table

0 1929 posted 11 years ago by jacktan

SQL SQL - SQL Server - Add Column with Default Value and Check Constraint

Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.

table

0 2932 posted 14 years ago by denakitan

SQL Update table with values selected in a subquery

The inner join could be nested too

table

0 1925 posted 14 years ago by preasha

SQL SQL Template - Drop Column

My Drop Column.sql This template drops a columns of the table.

table

0 1315 posted 15 years ago by edwinet

SQL SQL Template - Add Column

My Add Column Varchar.sql This template adds a new varchar column to the table.

table

0 1449 posted 15 years ago by edwinet

SQL Postgres get table schema with columns

Get table schema with columns via sql.

table

0 1457 posted 15 years ago by djmornyc

SQL mysql dump single table

Backup a single table from a database

table

0 1488 posted 15 years ago by tribal

SQL Check temporary table exists

Verify whether temporary table created is exists or not

table

1 1753 posted 15 years ago by hairajeshk

SQL Using temporary TABLE

table

1 1581 posted 15 years ago by RealRover

SQL Script table as INSERTS

table

1 1864 posted 16 years ago by CDIDevs

SQL Create a Temporary table within a SQL Stored Procedure

A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table. Don't forget to Drop the table after the SELECT * FROM #TempTableName at the end.

table

2 2191 posted 16 years ago by highlyevolved

SQL Return a table list with row count

This will return a list of all the tables in a certain database along with their row count.

table

1 1746 posted 17 years ago by blackf0rk

SQL sql: Create minimum table

table

0 1546 posted 17 years ago by smoover

SQL Import data from tab - delimited datafile to SQL table.

Fields are tab delimited and need to match table schema. I've found the tab separator ASCII(009) preferable over using a comma. The second version can help remove double quotation marks around character fields. Don't forget the keyword LOC...

table

0 2024 posted 17 years ago by RICHARDP

SQL MySQL Table - US States

This will create and then populate a MySQL table with a list of the names and USPS abbreviations for US states and possessions in existence.

table

3 4365 posted 17 years ago by cbrant

SQL MySQL Table - ISO Country List with Abbreviations

This will create and then populate a MySQL table with a list of the names and ISO 3166 codes for countries in existence.

table

5 3726 posted 17 years ago by cbrant