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 808 posted 15 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 710 posted 15 years ago by gembry

SQL Selecting a Random Row From Oracle

Oracle

0 819 posted 15 years ago by jordantbro

SQL Selecting a Random Row In Microsoft SQL Server

server
sql

0 852 posted 15 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 770 posted 15 years ago by mynameisharry

SQL user innodb in mysql

0 526 posted 15 years ago by manec

SQL rename a column is MS SQL

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

0 776 posted 15 years ago by naspinski

SQL Duplicate or clone one or more rows in MySQL

mysql
sql

1 2805 posted 15 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 855 posted 15 years ago by liuran

SQL Select the primary key for a table

mysql

0 808 posted 15 years ago by jachin

SQL mysql php get enum values

mysql
php

0 876 posted 15 years ago by ginoplusio

SQL mysql update replace

0 678 posted 15 years ago by ginoplusio

SQL Copy selection from one table to another with changes

0 946 posted 15 years ago by janetmck

SQL MYSQL add counter in query

mysql
sql

1 865 posted 15 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql
sql

1 782 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 910 posted 16 years ago by ginoplusio

SQL MySQL reset autoindex

mysql

1 537 posted 16 years ago by ericserrat

SQL Sort results by order in list

0 1172 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 1049 posted 16 years ago by RICHARDP

SQL update a field in mysql

mysql

0 793 posted 16 years ago by therobot

SQL Change user password in mediawiki

mysql

0 752 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 794 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 737 posted 16 years ago by simplistik

SQL SQL Shrink Transaction Log

0 764 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 706 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 586 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 1460 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 1687 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 1093 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 2902 posted 16 years ago by cbrant