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

SQL mysql pivot data

mysql

0 657 posted 8 years ago by ktrout

SQL mysql procedure throw_error

procedure to throw application defined error

mysql

0 655 posted 8 years ago by ktrout

SQL mysql rank with ties

calculate rank ( with ties ) over points table

mysql

0 775 posted 8 years ago by ktrout

SQL mysql clone table with structure and indexes

clone table with structure and indexes

mysql

0 783 posted 8 years ago by ktrout

SQL mysql unroll variable length string list

unroll variable length string list to normalised form.

mysql

0 649 posted 8 years ago by ktrout

SQL mysql tablename search information schema

search for tables in mysql catalog ( information_schema )

mysql

0 671 posted 8 years ago by ktrout

SQL mysql batch sql statements

stored procedure for executing batch sql statements

mysql

0 633 posted 8 years ago by ktrout

SQL mysql calendar table

creates a minimal calendar table

mysql

0 857 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 639 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 1103 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 536 posted 10 years ago by kidmizere

SQL Change user password in mySQL

How to change user password for a wordpress site.

mysql

0 663 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 773 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 670 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 568 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 609 posted 12 years ago by the_construct

SQL if mysql_query is not empty

mysql

0 712 posted 12 years ago by cesarkohl

SQL Cursor in Mysql

mysql

0 546 posted 12 years ago by georgemathewkunnathoor

SQL Replace local db with new URL

run these in the SQL tab

mysql

0 581 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...