Login / Register

Share Snipplr

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 660 posted 14 years ago by nate63179

Rails Rails: Backup a mysql database script

mysql

0 687 posted 14 years ago by nate63179

MySQL MySQL REGEX match comma-delimitted list

mysql

1 803 posted 14 years ago by j4kp07

PHP mysql_safe_query to prevent SQL injection

mysql

3 1170 posted 14 years ago by jmiller

SQL Importing a MySQL database in Windows

mysql

1 732 posted 14 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 724 posted 14 years ago by tobewan

Bash Get MySQL variable from command line

mysql

0 745 posted 14 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 612 posted 14 years ago by danshields

Bash Start / Stop MySQL server on Mac OSX

mysql

1 690 posted 14 years ago by oslego

PHP Export to MS Excel for MySQL Database

mysql

2 643 posted 14 years ago by SteveMcDaniel

Bash MySQL Backup Script

mysql

1 666 posted 14 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 739 posted 14 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 606 posted 14 years ago by cherbert

PHP How to Code a Signup Form with Email Confirmation

mysql

0 845 posted 14 years ago by paulgrenwood

MySQL Delete Orphaned Records

mysql

1 553 posted 14 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 699 posted 14 years ago by daveismyname

Bash insert backed up dumps from mysql

mysql

0 527 posted 14 years ago by 1b0t

MySQL Import MySQL dumpfile into database

mysql

0 633 posted 14 years ago by danshields

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

mysql

0 931 posted 14 years ago by AzizLight

MySQL Dump database mysql commandline

Remove <>

mysql

0 757 posted 14 years ago by jodm

PHP Print last query |Â CodeIgniter

mysql

3 845 posted 14 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)