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 Tagged mysql

« Prev 1 2 3 Next »

SQL Insert or Update Record if Unique Key Already Exists

This snippet allows you to insert new record into table. In case a unique key already exists - it updates appropriate fields only, leaving other fields untouched.

mysql

0 3654 posted 8 years ago by apphp-snippets

SQL mysql pivot data

mysql

0 2228 posted 9 years ago by ktrout

SQL mysql procedure throw_error

procedure to throw application defined error

mysql

0 2260 posted 9 years ago by ktrout

SQL mysql rank with ties

calculate rank ( with ties ) over points table

mysql

0 2286 posted 9 years ago by ktrout

SQL mysql clone table with structure and indexes

clone table with structure and indexes

mysql

0 2505 posted 9 years ago by ktrout

SQL mysql unroll variable length string list

unroll variable length string list to normalised form.

mysql

0 2241 posted 9 years ago by ktrout

SQL mysql tablename search information schema

search for tables in mysql catalog ( information_schema )

mysql

0 1261 posted 9 years ago by ktrout

SQL mysql batch sql statements

stored procedure for executing batch sql statements

mysql

0 2236 posted 9 years ago by ktrout

SQL mysql calendar table

creates a minimal calendar table

mysql

0 2436 posted 9 years ago by ktrout

SQL mysql sequence generator ( decimal definition )

one cross join for each ai in definition of decimal number as sum(ai*10^i)

mysql

0 2188 posted 9 years ago by ktrout

SQL A light implementation of Session table in Mysql 5.6 using memory engine

caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.

mysql

0 3077 posted 11 years ago by prgrmmraben

SQL Adding Linked Server to MSSQL

Adding a linked server to MSSQL account - particularly a MYSQL server

mysql

0 1229 posted 11 years ago by kidmizere

SQL Change user password in mySQL

How to change user password for a wordpress site.

mysql

0 1217 posted 12 years ago by keidash

SQL Backup Export MySQL Database using mysqldump and compress gzip it

Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------

mysql

0 1765 posted 13 years ago by MohamedAlaa

SQL Import MySQL Dumpfile, SQL Datafile Into My Database

Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql

mysql

0 1255 posted 13 years ago by MohamedAlaa

SQL Manual activation of a module in Joomla!

in order to avoid the .zip madness when creating a new module, you can make it available in the backend by firing a simple SQL in your DB. (mod_media is the name of the folder that holds it)

mysql

0 1208 posted 13 years ago by iroybot

SQL Where clause to select multiple rows of unique values

Where clause to select multiple rows of unique values

mysql

0 1232 posted 13 years ago by the_construct

SQL if mysql_query is not empty

mysql

0 1331 posted 14 years ago by cesarkohl

SQL Cursor in Mysql

mysql

0 1077 posted 14 years ago by georgemathewkunnathoor

SQL Replace local db with new URL

run these in the SQL tab

mysql

0 1165 posted 14 years ago by xcsteve99

SQL SQL Query to create a table in MySQL to store tweets

[Query related to PHP code to save tweets from the twitter search API to a MySQL database](http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ "PHP code to save tweets from the twitter search API to a...