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 sql

« Prev 1 ... 8 9 10 11 12 ... 17 Next »

SQL Split table MySQL

0 1125 posted 15 years ago by JohnnyGamba

MySQL Create utf8 database cli

0 1523 posted 15 years ago by hamsterbacke82

SQL Actualizar, Eliminar llaves primarias de una tabla y sus tablas hijas

0 1443 posted 15 years ago by JohnnyGamba

PHP Prevenir SQL inject - bÃ¡sico

Existen varias formas para hacerlo, pero lo que dejo aquÃ es a lo que tenemos que acostumbrarnos a hacer cada vez que programemos para prevenir que se pueda inyectar HTML o modificar las consultas SQL.\r\n\r\nThere are several ways to do it, but wha...

0 1228 posted 15 years ago by arucordoba

PHP Custom Taxonomy post listing filter for WordPress with sort options

0 2199 posted 15 years ago by errkk

C# create aspnet db in sql from .net tools

create aspnet db in sql from .net tools

1 2063 posted 15 years ago by hairajeshk

SQL Agreagar 0 a la izquierda de un numero o fecha. Padleft

0 1748 posted 15 years ago by ramirocalero

PHP Writing fields into a database

By using this php snippnet we can store different fields (got by array post) into a sql database

1 1612 posted 15 years ago by juanchifc

PHP Recover fields from a database

By using this snippnet we can recover and show on a table the items stored into a sql database managed with mysql.

1 1596 posted 15 years ago by juanchifc

MySQL Move WordPress to another host

SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.

1 1780 posted 15 years ago by errkk

SQL Updating guid for posts and pages in Wordpress database

1 2780 posted 15 years ago by arnach

SQL Check Server Property

1 1313 posted 15 years ago by okepaing

SQL To sort varchar fields which contain numeric data

To sort varchar fields which contain numeric data & returning XML

0 1361 posted 15 years ago by aunlead

SQL SQL - Find and Replace

3 2074 posted 15 years ago by jamiebrwr

PHP Display wordpress posts with custom date meta value, ordered by this date,

First you have to add a custom value with a correct date format. The lines: `AND CAST(wpostmeta.meta_value AS DATE) > '".date("Y-m-d H:i:s")."' AND CAST(wpostmeta.meta_value AS DATE) < '".date("Y-m-d H:i:s", $date2)."' ` are only used to select d...

0 2399 posted 15 years ago by Mat_

PL/SQL Update da table a table

0 3815 posted 15 years ago by tuffo19

SQL Select Duplicates

1 1459 posted 15 years ago by traeregan

SQL Find and Replace in SQLite

1 2144 posted 15 years ago by traeregan

SQL sql filter column by csv string

2 1678 posted 15 years ago by samwa

SQL Search stored procedures

2 1462 posted 15 years ago by samwa

SQL Drop all connections to a sql 2005 database

2 2169 posted 15 years ago by samwa

Other sql field varchar

0 1181 posted 15 years ago by foertel

PHP Debug last TYPO3 SQL-Statement

You can get the last query by using the following code. Insert the first line before the query and TYPO3 will store each query. You can get the last query with the second line.

3 2109 posted 15 years ago by pogosheep

Other sql select statement

0 1392 posted 15 years ago by florin555

SQL Script all Foreign Key Constraints - Result Set can be used to DROP constraints for 'TableName'

1 1717 posted 15 years ago by g8rpal

SQL Script all Foreign Key Constraints - Result Set can be used to copy constraints to your testing DB or to keep on hand in case of

1 3211 posted 15 years ago by g8rpal

SQL SQL SERVER â€“ 2005 â€“ Find Tables With Foreign Key Constraint in Database

1 2268 posted 15 years ago by g8rpal

SQL only select date part from datetime

1 1929 posted 15 years ago by g8rpal

SQL ms sql server date format convert

1 1562 posted 15 years ago by cjcdeleon

C# SQL Output Parameters

2 1852 posted 15 years ago by jx_boi