Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged mysql



« Prev 1 2 3
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.
0 912 posted 6 years ago by apphp-snippets
pivot data. input source query in the form : +--------+-----------+-------------+-------------+ | name | pivot_fid | pivot_fname | pivot_value | +--------+-----------+-------------+-------------+ | apple | 1 | is red...
0 642 posted 8 years ago by ktrout
procedure to throw application defined error
0 638 posted 8 years ago by ktrout
calculate rank ( with ties ) over points table
0 760 posted 8 years ago by ktrout
clone table with structure and indexes
0 760 posted 8 years ago by ktrout
unroll variable length string list to normalised form.
0 628 posted 8 years ago by ktrout
search for tables in mysql catalog ( information_schema )
0 650 posted 8 years ago by ktrout
stored procedure for executing batch sql statements
0 618 posted 8 years ago by ktrout
creates a minimal calendar table
0 821 posted 8 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0 618 posted 8 years ago by ktrout
caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.
0 1072 posted 9 years ago by prgrmmraben
Adding a linked server to MSSQL account - particularly a MYSQL server
0 523 posted 10 years ago by kidmizere
How to change user password for a wordpress site.
0 638 posted 10 years ago by keidash
Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------
0 744 posted 11 years ago by MohamedAlaa
Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql
0 647 posted 11 years ago by MohamedAlaa
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)
0 548 posted 12 years ago by iroybot
Where clause to select multiple rows of unique values
0 581 posted 12 years ago by the_construct
0 685 posted 12 years ago by cesarkohl
0 535 posted 12 years ago by georgemathewkunnathoor
run these in the SQL tab
0 564 posted 12 years ago by xcsteve99
[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...
0 1161 posted 12 years ago by eddequincey
0 719 posted 12 years ago by BFTrick
0 396 posted 13 years ago by markbenfield
Cronjob and PHP examples below
0 512 posted 13 years ago by sdxxx
0 533 posted 13 years ago by metoikos
Only works if you have the mysql-root password
0 598 posted 13 years ago by isholgueras
Backup a single table from a database
0 577 posted 13 years ago by tribal
« Prev 1 2 3