Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

Delete from table with limit (mySQL)
0 869 posted 9 years ago by Kcko
query with count having
0 795 posted 9 years ago by ironcrema
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???')
0 875 posted 9 years ago by imbraz
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 --
0 914 posted 9 years ago by supupoff
Sets up the database for my project management software (in development - C#)
0 855 posted 10 years ago by JordanRowles
Format a mysql datetime into a PHP date
0 798 posted 10 years ago by flatearthcomms
Adding a linked server to MSSQL account - particularly a MYSQL server
0 555 posted 10 years ago by kidmizere
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...
0 959 posted 10 years ago by apphp-snippets
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.
0 829 posted 10 years ago by apphp-snippets
This post will explain you the use of Event scheduler in MySQL.
0 795 posted 10 years ago by kp32
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.
0 798 posted 10 years ago by donkeykong
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...
0 641 posted 10 years ago by CreativePunch
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...
1 871 posted 10 years ago by crypticsoft
Convierte un campo de una tabla a llave foránea
0 736 posted 10 years ago by ironcrema
Modify Column for Table Of Mysql
0 885 posted 10 years ago by lyroge
Drop and Add Column for Table of Mysql
0 912 posted 10 years ago by lyroge
Drop and Add Index for Table of Mysql
0 893 posted 10 years ago by lyroge
Prints out a list of any field containing duplicates with count
0 777 posted 10 years ago by flatearthcomms
Reset MySQL root password
0 719 posted 10 years ago by Aminreza
How to change user password for a wordpress site.
0 686 posted 10 years ago by keidash
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...
1 849 posted 10 years ago by derbenni
Import/export gunzipped compressed mysql database
0 741 posted 10 years ago by tzvio
Connecting to Oracle using Java JDBC
0 555 posted 11 years ago by roizaig
Le fonction COALESCE de MySQL permet de renvoyer une valeur par défaut si la valeur null est renvoyée initialement.
0 1005 posted 11 years ago by pruntrut
By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT
0 780 posted 11 years ago by tucq88
batch accounts import into discuz with python
0 1113 posted 11 years ago by dylanninin
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 }...
1 939 posted 11 years ago by halk
How to find a given column in a given database in MySQL
1 757 posted 11 years ago by philsown