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

« Prev 1 ... 13 14 15 16 17 18 Next »

SQL Select random row from a SQL database.

This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.

mysql
sql

1 1844 posted 17 years ago by xtheonex

SQL Getting Count's with a UNION of two tables

I was having the hardest time getting this to work. It's a collection of various items. For whatever reason, I needed to include the CASE statement due to NULL's coming back. If this helps you out... go for it.

server
sql

0 1641 posted 17 years ago by gembry

SQL Selecting a Random Row From Oracle

Oracle

0 1793 posted 17 years ago by jordantbro

SQL Selecting a Random Row In Microsoft SQL Server

server
sql

0 1834 posted 17 years ago by jordantbro

SQL Creating a random password using dictionary table

Create a random password using a Dictionary database table. Selects a random word, and then appends two random numbers to the end, creating passwords in the form of: foozling98 or laicism11

1 1719 posted 17 years ago by mynameisharry

SQL user innodb in mysql

0 1214 posted 17 years ago by manec

SQL rename a column is MS SQL

Just replace TABLENAME.OLD_COLUMNNAME and NEW_COLUMNNAME with your new values.

0 1604 posted 17 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

mysql
sql

1 4456 posted 17 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 1819 posted 17 years ago by liuran

SQL Select the primary key for a table

mysql

0 1819 posted 17 years ago by jachin

SQL mysql php get enum values

mysql
php

0 1900 posted 17 years ago by ginoplusio

SQL mysql update replace

0 1505 posted 17 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 2044 posted 17 years ago by janetmck

SQL MYSQL add counter in query

mysql
sql

1 1816 posted 17 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql
sql

1 1797 posted 17 years ago by pointer

SQL SQL case sensitive match for user and password

When you make a login remember to use CASE SENSITIVE on password and case insensitive on username

0 1992 posted 17 years ago by ginoplusio

SQL MySQL reset autoindex

mysql

1 1301 posted 17 years ago by ericserrat

SQL Sort results by order in list

0 2254 posted 17 years ago by Wardy

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

0 2104 posted 17 years ago by RICHARDP

SQL update a field in mysql

mysql

0 1751 posted 17 years ago by therobot

SQL Change user password in mediawiki

mysql

0 1562 posted 17 years ago by hdanniel

SQL Find all categories NOT used in current item

It's easy to find the categories used on one item, but find all categories NOT used on current item? This snippet stores a "NOT IN" query. This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to w...

query

0 1714 posted 17 years ago by stavelin

SQL 50 States & Washington D.C.

Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.

mysql

1 1566 posted 17 years ago by simplistik

SQL SQL Shrink Transaction Log

0 1648 posted 17 years ago by DaveChild

SQL SQL Rebuild Dev Database

This script should be run from the "master" database. It will destroy the dev copy of a database and restore from the live copy. Code slightly modified from original (linked).

database

0 1563 posted 17 years ago by DaveChild

SQL Delete Dulicate Rows in MySQL

Where bad_table is the name of the table containing duplicate rows.

mysql

2 1457 posted 17 years ago by jdbartlett

SQL Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.

Oracle
sql

0 2875 posted 17 years ago by retry

SQL MySQL Find and Replace Drupal filepaths in files table

This is useful if you are changing a Drupal site's file upload path and/or changing from a private to a public file store.

drupal
mysql

3 3036 posted 17 years ago by shrop

SQL Importing data from (Excel) CSV into MySQL

Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.

4 2459 posted 18 years ago by jarnaldich

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.

3 4490 posted 18 years ago by cbrant