Welcome To Snipplr


Everyone's Recent SQL Snippets



Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.
0 725 posted 15 years ago by rengber
This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.
1 592 posted 15 years ago by xtheonex
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.
0 533 posted 15 years ago by gembry
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 582 posted 15 years ago by mynameisharry
0 372 posted 15 years ago by manec
Just replace TABLENAME.OLD_COLUMNNAME and NEW_COLUMNNAME with your new values.
0 590 posted 15 years ago by naspinski
get some random record from mysql quickly。
0 624 posted 15 years ago by liuran
0 622 posted 15 years ago by jachin
0 661 posted 15 years ago by ginoplusio
0 504 posted 15 years ago by ginoplusio
1 617 posted 15 years ago by ginoplusio
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 706 posted 15 years ago by ginoplusio
1 377 posted 15 years ago by ericserrat
0 897 posted 15 years ago by Wardy
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 814 posted 15 years ago by RICHARDP
0 583 posted 15 years ago by therobot
0 575 posted 15 years ago by hdanniel
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...
0 580 posted 15 years ago by stavelin
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
1 552 posted 15 years ago by simplistik
0 569 posted 15 years ago by DaveChild
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).
0 509 posted 15 years ago by DaveChild
Where bad_table is the name of the table containing duplicate rows.
2 422 posted 15 years ago by jdbartlett
This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.
0 1206 posted 15 years ago by retry
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.
3 1427 posted 15 years ago by shrop
Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.
4 880 posted 15 years ago by jarnaldich