Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets

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 1140 posted 14 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 682 posted 14 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 2179 posted 14 years ago by cbrant

SQL MySQL Table - ISO Country List with Abbreviations

This will create and then populate a MySQL table with a list of the names and ISO 3166 codes for countries in existence.

5 1003 posted 14 years ago by cbrant

SQL Comma-Delimited List using Coalesce

If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

list
sql

0 402 posted 14 years ago by mcbutterbuns

SQL MySQL random password string

mysql

1 545 posted 14 years ago by stancell

SQL Storing an IP address in a database table

You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP s...

0 644 posted 14 years ago by zingo

SQL Grant MySQL Privileges

To grant all privileges to a user from any location login to the mysql shell and run the following queries.

3 475 posted 14 years ago by cbrant

SQL Set MySQL root password

To reset the MySQL root password, login to the mysql shell and run the following commands.

1 489 posted 14 years ago by cbrant

SQL UPDATE, falls Eintrag schon vorhanden, sonst INSERT

Wenn ein INSERT einen doppelten Wert erzeugen wÃ¼rde, wird das UPDATE ausgefÃ¼hrt.

mysql
update

1 361 posted 14 years ago by drk

SQL TSQL for Recursive Select Using Common Table Expressions

0 563 posted 14 years ago by rengber

SQL MySQL Commands I wish I could remember

https://www.chrisjmendez.com/2008/03/23/mysql-commands-i-wish-i-could-remember/

mysql
sql

9 536 posted 14 years ago by chrisaiv

SQL SQL To Show WaitTime and other Process Stats

0 445 posted 14 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 613 posted 14 years ago by rengber

SQL Update from select

sql
update

4 561 posted 14 years ago by wolfie

SQL TSQL to Reset a Tables Primary Key Autonumber

database
sql

0 433 posted 14 years ago by rengber

SQL Rendering Query Results in Vertical Format

mysql
query

0 529 posted 14 years ago by Abe

SQL Create a CSV File From Query Results

2 824 posted 14 years ago by Abe

SQL Date 0000-00-00

An easy way to handle null dates. If date = 0000-00-00 then null, else use date

date
sql

0 560 posted 14 years ago by Abe

SQL See all mysql grants

It does not show the grants themselves, but shows all users with grants.

mysql

0 468 posted 15 years ago by therobot

SQL Differences between two Tables

mysql
sql

1 593 posted 15 years ago by zingo

SQL Copy table into a new table

Oracle
sql

0 392 posted 15 years ago by Caliban

SQL Generate the SQL necessary to create triggers (Oracle)

Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with â€˜tblâ€™. It may need to be modified to work with different naming conventions.

Oracle
sql

0 397 posted 15 years ago by thecrumb

SQL Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create sequences for every table. NOTE: This doesnâ€™t create sequences. The results need to be copied and run as a script.