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 925 posted 15 years ago by nate63179

Rails Rails: Backup a mysql database script

mysql

0 974 posted 15 years ago by nate63179

MySQL MySQL REGEX match comma-delimitted list

mysql

1 1128 posted 15 years ago by j4kp07

PHP mysql_safe_query to prevent SQL injection

mysql

3 1484 posted 15 years ago by jmiller

SQL Importing a MySQL database in Windows

mysql

1 1011 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 960 posted 15 years ago by tobewan

Bash Get MySQL variable from command line

mysql

0 1042 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 877 posted 15 years ago by danshields

Bash Start / Stop MySQL server on Mac OSX

mysql

1 968 posted 15 years ago by oslego

PHP Export to MS Excel for MySQL Database

mysql

2 888 posted 15 years ago by SteveMcDaniel

Bash MySQL Backup Script

mysql

1 940 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 978 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 905 posted 15 years ago by cherbert

PHP How to Code a Signup Form with Email Confirmation

mysql

0 1158 posted 15 years ago by paulgrenwood

MySQL Delete Orphaned Records

mysql

1 794 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 981 posted 15 years ago by daveismyname

Bash insert backed up dumps from mysql

mysql

0 767 posted 15 years ago by 1b0t

MySQL Import MySQL dumpfile into database

mysql

0 902 posted 15 years ago by danshields

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

mysql

0 1264 posted 15 years ago by AzizLight

MySQL Dump database mysql commandline

Remove <>

mysql

0 1054 posted 15 years ago by jodm

PHP Print last query |Â CodeIgniter

mysql

3 1130 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)