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 2 3 4 5 ... 19 Next »

MySQL Delete from table with limit (mySQL)

Delete from table with limit (mySQL)

mysql

0 4239 posted 12 years ago by Kcko

MySQL consulta mysql count having

query with count having

mysql

0 4004 posted 12 years ago by ironcrema

MySQL Extract the column names of a table (so you can select many columns but exclude some)

This will get the names of all the columns as one long string ready to use in a select statement. N.B. There is a list of column names to exclude (In this case '???COLUMNS_TO_EXCLUDE???')

mysql

0 4501 posted 12 years ago by imbraz

Java Advanced Java mysql,oracle,... connect, full functions

use This Class to conenct to any database mysql oracle access and postgresql and use functions to select update insert or update data from database --

mysql

0 4183 posted 12 years ago by supupoff

MySQL Project Management Database Setup Script

Sets up the database for my project management software (in development - C#)

mysql

0 4559 posted 12 years ago by JordanRowles

PHP mySQL datetime to formatted PHP date

Format a mysql datetime into a PHP date

mysql

0 3261 posted 12 years ago by flatearthcomms

MySQL Add current date to date field that is null

mysql

0 4285 posted 12 years ago by jlmarks

MySQL get list of all values in a field MySQL

mysql

0 2706 posted 12 years ago by jlmarks

SQL Adding Linked Server to MSSQL

Adding a linked server to MSSQL account - particularly a MYSQL server

mysql

0 1970 posted 12 years ago by kidmizere

MySQL Find and Replace with MySQL

MySQL has a handy and simple string function REPLACE() that allows table data with the matching string to be replaced by new string. This is useful if there is need to search and replace a text string which affects many records or rows, such as chang...

mysql

0 4548 posted 12 years ago by apphp-snippets

MySQL Create a Database and Assign a User

This is a very simple snippet about how to create a database 1st, a user and then assign some privileges to the user to allow him/her to perform some specific actions like insert, create, update, select etc.

mysql

0 2474 posted 12 years ago by apphp-snippets

MySQL MySQL Event scheduler

This post will explain you the use of Event scheduler in MySQL.

mysql

0 4526 posted 12 years ago by kp32

MySQL MySQL Duplicate Rows With Updates

I found this script and tried it. It worked. I thought it was useful for a variety of situations and is easy to follow. Often times I need nearly duplicated data and don't want to manually cut and paste.

mysql

0 4203 posted 12 years ago by donkeykong

PHP Implementing Full-Text search in Laravel 4

In this tutorial I will go over implementing Full-Text search in Laravel 4 . Those who have used Laravel 3 in the past may remember that there used to be support for FULLTEXT indexes. This functionality has been removed in Laravel 4 but can still ea...

mysql

0 1921 posted 12 years ago by CreativePunch

PHP Pinnacle Cart PDO MySQL : Product Class

While the Pinnacle Cart API can handle some of this, I found it easier to query the database directly. This PCProduct class was developed for integrating Pinnacle Cart with WordPress with the following methods: - get_product($id) - get_product_by...

mysql

1 2349 posted 12 years ago by crypticsoft

MySQL Agregar LLave ForÃ¡nea MySql

Convierte un campo de una tabla a llave forÃ¡nea

mysql

0 4116 posted 12 years ago by ironcrema

MySQL Modify Column for Table Of Mysql

Modify Column for Table Of Mysql

mysql

0 4338 posted 13 years ago by lyroge

MySQL Drop and Add Column for Table of Mysql

Drop and Add Column for Table of Mysql

mysql

0 4340 posted 13 years ago by lyroge

MySQL Drop and Add Index for Table of Mysql

Drop and Add Index for Table of Mysql

mysql

0 4370 posted 13 years ago by lyroge

MySQL Find duplicate mysql field vale

Prints out a list of any field containing duplicates with count

mysql

0 4175 posted 13 years ago by flatearthcomms

MySQL MySQL_reset_root_pass

Reset MySQL root password

mysql

0 3891 posted 13 years ago by Aminreza

SQL Change user password in mySQL

How to change user password for a wordpress site.

mysql

0 1942 posted 13 years ago by keidash

Bash Create vHost with user and MySQL database

With this script a new user gets created and gets his own VirtualHost and database. The username is used for building the domain, so the username "test" leads to the domain test.local. The password for the MySQL account used for creating the datab...

mysql

1 2373 posted 13 years ago by derbenni

MySQL gunzip mysql import/export

Import/export gunzipped compressed mysql database

mysql

0 4107 posted 13 years ago by tzvio

Java Connecting to Oracle using Java JDBC

Connecting to Oracle using Java JDBC

mysql

0 1842 posted 13 years ago by roizaig

MySQL La fonction COALESCE de MySQL permet de renvoyer une valeur par dÃ©faut si la valeur null est renvoyÃ©e initialement.

mysql

0 4368 posted 13 years ago by pruntrut

MySQL [MySQL] Add condition to Virutal Fields

By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT

mysql

0 4084 posted 13 years ago by tucq88

Python batch accounts import into discuz with python

batch accounts import into discuz with python

mysql

0 2528 posted 13 years ago by dylanninin

PHP JSONP Public API with jQuery getJSON (callback) (MySql)

This is a public jsonp api. I use it with jQuery Like This: $.getJSON("http://yourdomain/yourpath/jsonp_api.php?method=getSchema&params=your_db_name&jsoncallback=?", function(data){ //DO SOMETHING WITH THE DATA HERE }...

mysql

1 2468 posted 13 years ago by halk

MySQL What MySQL Table Has What Column

How to find a given column in a given database in MySQL

mysql

1 3106 posted 13 years ago by philsown