Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

mysql sql drupal wordpress database mac osx convert textmate date command backup ip url replace find user list line table log update query data regex csv php terminal order email path search security unix mail magento Bash linux cache code copy regexp filter forms text joomla cakephp server customer class windows format web iphone ajax api xml android actionscript window animation magentoextension apache Business service

Welcome To Snipplr

Everyone's Recent MySQL Snippets

« Prev 1 2 3 4 5 6 7 Next »

MySQL Display MYSQL date as readable to us humans

1 1583 posted 15 years ago by flashmac

MySQL MySql Load Data

mysql

0 1240 posted 15 years ago by kaartz

MySQL Set MySQL Foreign Key Checks OFF

mysql

0 1489 posted 15 years ago by benrasmusen

MySQL MYSQL : changer le format d'un champs datetime dans un select

mysql
query

0 1749 posted 15 years ago by alexandrepayet

MySQL MySQL create table syntax

Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.

mysql

2 1477 posted 15 years ago by dkynyc

MySQL Show table creation syntax

View the syntax used to create a table called time_zone.

mysql

1 1279 posted 15 years ago by dkynyc

MySQL Show database creation syntax

Allows us to see the syntax used to create a database.

mysql

1 1327 posted 15 years ago by dkynyc

MySQL MySQL batch command

Issue commands via batch mode.

mysql

2 1410 posted 15 years ago by dkynyc

MySQL Move Column in MySQL Table

0 1495 posted 15 years ago by Jamie

MySQL Import Sql File into MySQL DB

mysql

1 1577 posted 15 years ago by electblake

MySQL Select Records older than one week

Display records older than one week.

mysql

1 1518 posted 15 years ago by galofre

MySQL Change Drupal file directory path

drupal

3 1584 posted 15 years ago by zachharkey

MySQL MySQL customers invoices

1 1021 posted 15 years ago by gcman105

MySQL MYSQL : Calcul sur des dates avec des fonctions dans mysql

0 1577 posted 15 years ago by alexandrepayet

MySQL add auto-imcremented column to existing table without ex- and reimporting

How to add an auto-incremented column to an existing table without ex- and reimporting.

mysql
table

0 1782 posted 15 years ago by simondiercks

MySQL MySQL Administation Snippet

Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)

mysql

0 1255 posted 16 years ago by zonetrooperex

MySQL Delete all Wordpress posts that carry a specific term ID

wordpress

0 1484 posted 16 years ago by tcmacdonald

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 1375 posted 16 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 1550 posted 16 years ago by xaviles

MySQL Control de Errores en SP MySQL (Basico)

Esquema de sentencias para el control de errores en SP de MYSQL. Es un metodo basico

mysql

0 1754 posted 16 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 1197 posted 16 years ago by yisreldov

MySQL Get rid of unused post revisions

Just run the following query on your WordPress database, and all revisions (As well as meta associated with it) will be deleted from your database.

wordpress

2 1691 posted 16 years ago by jessibird

MySQL MySQL Find and Replace

This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.

5 2098 posted 16 years ago by Jamie

MySQL Search and replace within a field with regex in MySQL

After a problem with row break in a text field I found this way of searching within a where clause in an SQL query. Can be used for selection or update / replace purposes of course.

regex
search

0 2335 posted 16 years ago by davidrinnan

MySQL MySQl table engine

General MySQL engine related commands

mysql
table

0 1330 posted 16 years ago by sukantahazra

MySQL Find values that occur exactly once in table

mysql

1 1215 posted 16 years ago by atma

MySQL Fing multiple values in MySQL

mysql

0 1334 posted 16 years ago by atma

MySQL calculate the difference between dates in one columns within the same table

I use something similar to the example to get the difference between statuses in a status log table that I have. It comes in handy when determining the number of days between status changes. This works in MySQL 5.0.

date
mysql

0 1820 posted 16 years ago by bradless

MySQL Show mysql database encoding

mysql

1 1474 posted 16 years ago by therobot

MySQL Wordpress updating URL paths after address change

If the official codex approach (http://codex.wordpress.org/Changing_The_Site_URL) is causing you problems, give this a try. Be sure to change the constant declarations and modify table names as necessary for your instance. Confirmed working with WP v...

1 2068 posted 16 years ago by johnandrewsroot