Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged mysql

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 938 posted 6 years ago by apphp-snippets

SQL mysql pivot data

mysql

0 653 posted 8 years ago by ktrout

SQL mysql procedure throw_error

procedure to throw application defined error

mysql

0 650 posted 8 years ago by ktrout

SQL mysql rank with ties

calculate rank ( with ties ) over points table

mysql

0 766 posted 8 years ago by ktrout

SQL mysql clone table with structure and indexes

clone table with structure and indexes

mysql

0 773 posted 8 years ago by ktrout

SQL mysql unroll variable length string list

unroll variable length string list to normalised form.

mysql

0 644 posted 8 years ago by ktrout

SQL mysql tablename search information schema

search for tables in mysql catalog ( information_schema )

mysql

0 666 posted 8 years ago by ktrout

SQL mysql batch sql statements

stored procedure for executing batch sql statements

mysql

0 625 posted 8 years ago by ktrout

SQL mysql calendar table

creates a minimal calendar table

mysql

0 846 posted 8 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 630 posted 8 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 1091 posted 9 years ago by prgrmmraben

SQL Adding Linked Server to MSSQL

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

mysql

0 532 posted 10 years ago by kidmizere

SQL Change user password in mySQL

How to change user password for a wordpress site.

mysql

0 652 posted 10 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 763 posted 11 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 658 posted 11 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 560 posted 12 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 599 posted 12 years ago by the_construct

SQL if mysql_query is not empty

mysql

0 702 posted 12 years ago by cesarkohl

SQL Cursor in Mysql

mysql

0 542 posted 12 years ago by georgemathewkunnathoor

SQL Replace local db with new URL

run these in the SQL tab

mysql

0 574 posted 12 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...