Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.
0 748 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 616 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 553 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 592 posted 15 years ago by mynameisharry
0 380 posted 15 years ago by manec
Just replace TABLENAME.OLD_COLUMNNAME and NEW_COLUMNNAME with your new values.
0 612 posted 15 years ago by naspinski
get some random record from mysql quickly。
0 647 posted 15 years ago by liuran
0 641 posted 15 years ago by jachin
0 678 posted 15 years ago by ginoplusio
0 519 posted 15 years ago by ginoplusio
1 632 posted 15 years ago by ginoplusio
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0 723 posted 15 years ago by ginoplusio
1 393 posted 15 years ago by ericserrat
0 931 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 836 posted 15 years ago by RICHARDP
0 604 posted 15 years ago by therobot
0 592 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 601 posted 15 years ago by stavelin
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
1 562 posted 15 years ago by simplistik
0 586 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 534 posted 15 years ago by DaveChild
Where bad_table is the name of the table containing duplicate rows.
2 429 posted 15 years ago by jdbartlett
This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.
0 1233 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 1446 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 895 posted 15 years ago by jarnaldich