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 3701 posted 11 years ago by Kcko

MySQL consulta mysql count having

query with count having

mysql

0 3492 posted 11 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 3875 posted 11 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 3642 posted 11 years ago by supupoff

MySQL Project Management Database Setup Script

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

mysql

0 3848 posted 11 years ago by JordanRowles

PHP mySQL datetime to formatted PHP date

Format a mysql datetime into a PHP date

mysql

0 2691 posted 11 years ago by flatearthcomms

MySQL Add current date to date field that is null

mysql

0 3702 posted 11 years ago by jlmarks

MySQL get list of all values in a field MySQL

mysql

0 2019 posted 11 years ago by jlmarks

SQL Adding Linked Server to MSSQL

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

mysql

0 1461 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 3954 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 1782 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 3571 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 3657 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 1443 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 1759 posted 12 years ago by crypticsoft

MySQL Agregar LLave ForÃ¡nea MySql

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

mysql

0 3560 posted 12 years ago by ironcrema

MySQL Modify Column for Table Of Mysql

Modify Column for Table Of Mysql

mysql

0 3743 posted 12 years ago by lyroge

MySQL Drop and Add Column for Table of Mysql

Drop and Add Column for Table of Mysql

mysql

0 3733 posted 12 years ago by lyroge

MySQL Drop and Add Index for Table of Mysql

Drop and Add Index for Table of Mysql

mysql

0 3754 posted 12 years ago by lyroge

MySQL Find duplicate mysql field vale

Prints out a list of any field containing duplicates with count

mysql

0 3586 posted 12 years ago by flatearthcomms

MySQL MySQL_reset_root_pass

Reset MySQL root password

mysql

0 3365 posted 12 years ago by Aminreza

SQL Change user password in mySQL

How to change user password for a wordpress site.

mysql

0 1416 posted 12 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 1793 posted 12 years ago by derbenni

MySQL gunzip mysql import/export

Import/export gunzipped compressed mysql database

mysql

0 3563 posted 12 years ago by tzvio

Java Connecting to Oracle using Java JDBC

Connecting to Oracle using Java JDBC

mysql

0 1384 posted 12 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 3789 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 3497 posted 13 years ago by tucq88

Python batch accounts import into discuz with python

batch accounts import into discuz with python

mysql

0 2054 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 1873 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 2569 posted 13 years ago by philsown