Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

« Prev 1 ... 10 11 12 13 14 ... 19 Next »

Rails Capistrano: Synchronize local mysql database to remote mysql database

This could be further abstracted to work with other db's. Also, it really should be using Ruby's Tempfile class instead of assuming the local machine is *NIX based, but it works :)

mysql

0 819 posted 15 years ago by nate63179

Rails Rails: Backup a mysql database script

mysql

0 838 posted 15 years ago by nate63179

MySQL MySQL REGEX match comma-delimitted list

mysql

1 1011 posted 15 years ago by j4kp07

PHP mysql_safe_query to prevent SQL injection

mysql

3 1363 posted 15 years ago by jmiller

SQL Importing a MySQL database in Windows

mysql

1 909 posted 15 years ago by Mithun

SQL Find all databases and login credentials

If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:

mysql

1 867 posted 15 years ago by tobewan

Bash Get MySQL variable from command line

mysql

0 941 posted 15 years ago by kurokikaze

Bash MySQL SSH Tunnel

Where: * 3307 is the local port used to connect to the remote database. You can use 3306, however, this could conflict with your PCâ€™s MySQL installation. * localhost and 3306 is the MySQL address from the remote server (most people will...

mysql

0 760 posted 15 years ago by danshields

Bash Start / Stop MySQL server on Mac OSX

mysql

1 855 posted 15 years ago by oslego

PHP Export to MS Excel for MySQL Database

mysql

2 795 posted 15 years ago by SteveMcDaniel

Bash MySQL Backup Script

mysql

1 827 posted 15 years ago by troynt

MySQL Get random record based on weight

Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.

mysql

1 885 posted 15 years ago by BFTrick

MySQL MySQL Insert Unique Reference

MySQL Insert Unique Reference using MAX() to obtain latest value Alternate solution to using Composite Primary Keys which INNODB engine does not support.

mysql

0 782 posted 15 years ago by cherbert

PHP How to Code a Signup Form with Email Confirmation

mysql

0 1037 posted 15 years ago by paulgrenwood

MySQL Delete Orphaned Records

mysql

1 703 posted 15 years ago by nkm

PHP Date format for mysql input

This snippet collects a date from a var and formats it into the correct format for database date entry

mysql

0 853 posted 15 years ago by daveismyname

Bash insert backed up dumps from mysql

mysql

0 672 posted 15 years ago by 1b0t

MySQL Import MySQL dumpfile into database

mysql

0 811 posted 15 years ago by danshields

PHP MySQL Natural Sort Order By on Non-Numeric Field Type

mysql

0 1112 posted 15 years ago by AzizLight

MySQL Dump database mysql commandline

Remove <>

mysql

0 940 posted 15 years ago by jodm

PHP Print last query |Â CodeIgniter

mysql

3 1025 posted 15 years ago by nkm

PHP Mysql query in PHP with proper error detection

Dumps whole query so developer can see where is error. However it's potential security issue, exposing SQL commands to attacker. (Recommended to use only during development, replace message code with some custom error text)