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

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 975 posted 16 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 839 posted 16 years ago by gembry

SQL Selecting a Random Row From Oracle

Oracle

0 974 posted 16 years ago by jordantbro

SQL Selecting a Random Row In Microsoft SQL Server

server
sql

0 1003 posted 16 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 900 posted 16 years ago by mynameisharry

SQL user innodb in mysql

0 633 posted 16 years ago by manec

SQL rename a column is MS SQL

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

0 897 posted 16 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

mysql
sql

1 3140 posted 16 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 1011 posted 16 years ago by liuran

SQL Select the primary key for a table

mysql

0 952 posted 16 years ago by jachin

SQL mysql php get enum values

mysql
php

0 1015 posted 16 years ago by ginoplusio

SQL mysql update replace

0 805 posted 16 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 1095 posted 16 years ago by janetmck

SQL MYSQL add counter in query

mysql
sql

1 1015 posted 16 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql
sql

1 956 posted 16 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 1068 posted 16 years ago by ginoplusio

SQL MySQL reset autoindex

mysql

1 652 posted 16 years ago by ericserrat

SQL Sort results by order in list

0 1336 posted 16 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 1198 posted 16 years ago by RICHARDP

SQL update a field in mysql

mysql

0 982 posted 16 years ago by therobot

SQL Change user password in mediawiki

mysql

0 875 posted 16 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 945 posted 16 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 879 posted 16 years ago by simplistik

SQL SQL Shrink Transaction Log

0 907 posted 16 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 873 posted 16 years ago by DaveChild

SQL Delete Dulicate Rows in MySQL

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

mysql

2 736 posted 16 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 1620 posted 16 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 1857 posted 16 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 1251 posted 16 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 3163 posted 16 years ago by cbrant