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 125 posted 3 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 70 posted 4 years ago by ktrout
procedure to throw application defined error
0 70 posted 4 years ago by ktrout
calculate rank ( with ties ) over points table
0 133 posted 4 years ago by ktrout
clone table with structure and indexes
0 97 posted 4 years ago by ktrout
unroll variable length string list to normalised form.
0 74 posted 4 years ago by ktrout
search for tables in mysql catalog ( information_schema )
0 68 posted 4 years ago by ktrout
stored procedure for executing batch sql statements
0 86 posted 4 years ago by ktrout
creates a minimal calendar table
0 86 posted 4 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0 76 posted 4 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 132 posted 5 years ago by prgrmmraben
Adding a linked server to MSSQL account - particularly a MYSQL server
0 52 posted 6 years ago by kidmizere
How to change user password for a wordpress site.
0 85 posted 6 years ago by keidash
Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------
0 99 posted 8 years ago by MohamedAlaa
Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql
0 98 posted 8 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 51 posted 8 years ago by iroybot
Where clause to select multiple rows of unique values
0 83 posted 8 years ago by the_construct
0 77 posted 8 years ago by cesarkohl
0 66 posted 8 years ago by georgemathewkunnathoor
run these in the SQL tab
0 70 posted 8 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 159 posted 8 years ago by eddequincey
0 108 posted 9 years ago by BFTrick
0 40 posted 9 years ago by markbenfield
Cronjob and PHP examples below
0 65 posted 9 years ago by sdxxx
0 51 posted 9 years ago by metoikos
Only works if you have the mysql-root password
0 63 posted 9 years ago by isholgueras
Backup a single table from a database
0 74 posted 9 years ago by tribal
« Prev 1 2 3