Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
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
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
[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