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 870 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 763 posted 16 years ago by gembry

SQL Selecting a Random Row From Oracle

Oracle

0 869 posted 16 years ago by jordantbro

SQL Selecting a Random Row In Microsoft SQL Server

server
sql

0 908 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 810 posted 16 years ago by mynameisharry

SQL user innodb in mysql

0 566 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 822 posted 16 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

mysql
sql

1 2937 posted 16 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 920 posted 16 years ago by liuran

SQL Select the primary key for a table

mysql

0 862 posted 16 years ago by jachin

SQL mysql php get enum values

mysql
php

0 923 posted 16 years ago by ginoplusio

SQL mysql update replace

0 732 posted 16 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 999 posted 16 years ago by janetmck

SQL MYSQL add counter in query

mysql
sql

1 934 posted 16 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql
sql

1 844 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 971 posted 16 years ago by ginoplusio

SQL MySQL reset autoindex

mysql

1 578 posted 16 years ago by ericserrat

SQL Sort results by order in list

0 1234 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 1106 posted 16 years ago by RICHARDP

SQL update a field in mysql

mysql

0 860 posted 16 years ago by therobot

SQL Change user password in mediawiki

mysql

0 807 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 845 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 790 posted 16 years ago by simplistik

SQL SQL Shrink Transaction Log

0 828 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 762 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 632 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 1520 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 1753 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 1153 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 3011 posted 16 years ago by cbrant