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 ... 14 15 16 17 18 Next »

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 1681 posted 16 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 799 posted 16 years ago by mcbutterbuns

SQL MySQL random password string

mysql

1 922 posted 16 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 1136 posted 16 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 922 posted 16 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 853 posted 16 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 684 posted 16 years ago by drk

SQL TSQL for Recursive Select Using Common Table Expressions

0 956 posted 16 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 949 posted 16 years ago by chrisaiv

SQL SQL To Show WaitTime and other Process Stats

0 814 posted 16 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 1026 posted 16 years ago by rengber

SQL Update from select

sql
update

4 1030 posted 16 years ago by wolfie

SQL TSQL to Reset a Tables Primary Key Autonumber

database
sql

0 798 posted 16 years ago by rengber

SQL See all mysql grants

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

mysql

0 854 posted 17 years ago by therobot

SQL Differences between two Tables

mysql
sql

1 1060 posted 17 years ago by zingo

SQL Copy table into a new table

Oracle
sql

0 759 posted 17 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 768 posted 17 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.