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 424 posted 14 years ago by gembry

SQL Selecting a Random Row From Oracle

Oracle

0 483 posted 14 years ago by jordantbro

SQL Selecting a Random Row In Microsoft SQL Server

server
sql

0 478 posted 14 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 459 posted 14 years ago by mynameisharry

SQL user innodb in mysql

0 304 posted 14 years ago by manec

SQL rename a column is MS SQL

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

0 454 posted 14 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

mysql
sql

1 1671 posted 14 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 488 posted 14 years ago by liuran

SQL Select the primary key for a table

mysql

0 500 posted 14 years ago by jachin

SQL mysql php get enum values

mysql
php

0 532 posted 14 years ago by ginoplusio

SQL mysql update replace

0 388 posted 14 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 596 posted 14 years ago by janetmck

SQL MYSQL add counter in query

mysql
sql

1 474 posted 14 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql
sql

1 479 posted 14 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 555 posted 14 years ago by ginoplusio

SQL MySQL reset autoindex

mysql

1 291 posted 14 years ago by ericserrat

SQL Sort results by order in list

0 672 posted 14 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 638 posted 14 years ago by RICHARDP

SQL update a field in mysql

mysql

0 464 posted 14 years ago by therobot

SQL Change user password in mediawiki

mysql

0 447 posted 14 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 431 posted 14 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 403 posted 14 years ago by simplistik

SQL SQL Shrink Transaction Log

0 448 posted 14 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).