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