Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



1 ... 12 13 14 15 16 ... 19
0 1770 posted 17 years ago by jonniespratley
I am currently still working on this, and will make changes.
1 2008 posted 17 years ago by jonniespratley
I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory lis...
0 1704 posted 17 years ago by cori
1 2031 posted 17 years ago by vasilije
0 1691 posted 17 years ago by oli
0 1774 posted 17 years ago by stavelin
I currently have project_issue nodes set for replacement pattern issues/issue[nid] in Drupal 5.x PathAuto. This query fixes all of the URL aliases for entries created before this was set correctly.
0 1810 posted 17 years ago by tgbdad
This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.
1 1920 posted 17 years ago by xtheonex
0 1747 posted 17 years ago by vasilije
1 1593 posted 17 years ago by ping_ch
0 1843 posted 17 years ago by jonniespratley
0 1643 posted 17 years ago by moonbather
# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or do...
6 2599 posted 17 years ago by mikegreen
1 1434 posted 17 years ago by endorfin
0 1482 posted 17 years ago by endorfin
0 1690 posted 17 years ago by rowntreerob
To connect to your database remotely, tunnel in via SSH. This creates an encrypted tunnel to your Slice’s mySQL port (3306) on your local port of 8888. Point your local admin/GUI app to localhost:8888. If this does not work, and you are running...
3 2089 posted 17 years ago by zachwood
1 1897 posted 17 years ago by iTony
Simple but useful function for getting a single piece of data from a database and placing it straight into a variable. Example: $variable = one_result("SELECT columnOne FROM table WHERE columnTwo=whatever"); This would insert the value of colu...
1 1548 posted 17 years ago by iridium
how to rollback data on grails' service .... for myutil --> please look at
0 1877 posted 17 years ago by callmeblessed
I need to create all table in InnoDB in my grails application. you can add this / edit the following code on grails-app/conf/Datasource.groovy
1 2757 posted 17 years ago by callmeblessed
get some random record from mysql quickly。
0 1899 posted 17 years ago by liuran
0 1902 posted 17 years ago by jachin
0 1979 posted 17 years ago by ginoplusio
Some other alter syntax examples at the URL, which beats the pants off the MySQL manual for some reason.
0 1925 posted 17 years ago by tclancy
Quick little snippet for changing the ordering of a field in a MYSQL database.
1 2083 posted 17 years ago by Zync
1 ... 12 13 14 15 16 ... 19