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

Welcome To Snipplr

Everyone's Recent MySQL Snippets

« Prev 1 2 3 4 5 6 7 Next »

MySQL A request to clear a single column in a table / MySQL /

A request to clear a single column in a table / MySQL /

0 12034 posted 5 years ago by cerxx

MySQL mysql make access global

This commands are useful in creating a username in mysql and it can be used to access the mysql globally with this username.

mysql

0 1002 posted 6 years ago by surentharp

MySQL Get Random Record Based on Weight

This snippet allows you to get random record from given table by weight. To run it, it must have a field named "weight". The more "weight" is assigned, the more often the record is selected. The value of "weight" should be an integer between 1 and 10...

mysql

0 1201 posted 7 years ago by apphp-snippets

MySQL Configuration Mysql 5.7

Some configurations for mysql 5.7

mysql

0 931 posted 7 years ago by ironcrema

MySQL Show the output of a query in a more readable vertical format

Show the output of a query in a more readable vertical format

0 1154 posted 8 years ago by rm1984

MySQL Update password in Liferay Portal from db

Thanks to Paras Jain

user

0 943 posted 8 years ago by yhauxell

MySQL Find last two updates to a record

Created as reply to question on ittoolbox.com:"Need your help in writing a query to pull audit history i.e. Last updated by a user 'XYZ' and for the same record key (ID) the second last record in the audit history table. i.e. Last update by this user...

date
sql

0 1024 posted 9 years ago by bvwatson

MySQL Mysql - Convertir todas las columnas en colaciÃ³n utf8

Consulta que permite convertir todas las tablas en colaciÃ³n utf8

convert

0 1069 posted 9 years ago by ironcrema

MySQL A example option file for mysql in windows

`mysql-dev.ini` can be used in a developing environment and put it in the Mysql Home dir

0 1152 posted 10 years ago by jacktan

MySQL Mysql find duplicate values in field

Mysql find duplicate values in field

find
mysql

0 1119 posted 10 years ago by flatearthcomms

MySQL Delete from table with limit (mySQL)

Delete from table with limit (mySQL)

mysql

0 1052 posted 10 years ago by Kcko

MySQL consulta mysql count having

query with count having

mysql

0 987 posted 10 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 1051 posted 10 years ago by imbraz

MySQL Project Management Database Setup Script

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

0 1040 posted 10 years ago by JordanRowles

MySQL Add current date to date field that is null

date
mysql

0 1046 posted 10 years ago by jlmarks

MySQL get list of all values in a field MySQL

mysql

0 1162 posted 10 years ago by jlmarks

MySQL Replace String MySql

Replace string mysql

replace

0 945 posted 10 years ago by ironcrema

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...

0 1166 posted 10 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.

0 1043 posted 10 years ago by apphp-snippets

MySQL MySQL Event scheduler

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

mysql

0 969 posted 10 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.