Login / Register

Share Snipplr

Follow @Snipplr

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 8670 posted 3 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 607 posted 4 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 689 posted 5 years ago by apphp-snippets

MySQL Configuration Mysql 5.7

Some configurations for mysql 5.7

mysql

0 582 posted 6 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 731 posted 6 years ago by rm1984

MySQL Update password in Liferay Portal from db

Thanks to Paras Jain

user

0 573 posted 7 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 665 posted 8 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 644 posted 8 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 711 posted 8 years ago by jacktan

MySQL Mysql find duplicate values in field

Mysql find duplicate values in field

find
mysql

0 671 posted 8 years ago by flatearthcomms

MySQL Delete from table with limit (mySQL)

Delete from table with limit (mySQL)

mysql

0 657 posted 8 years ago by Kcko

MySQL consulta mysql count having

query with count having

mysql

0 598 posted 8 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 658 posted 8 years ago by imbraz

MySQL Project Management Database Setup Script

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

0 609 posted 9 years ago by JordanRowles

MySQL Add current date to date field that is null

date
mysql

0 636 posted 9 years ago by jlmarks

MySQL get list of all values in a field MySQL

mysql

0 723 posted 9 years ago by jlmarks

MySQL Replace String MySql

Replace string mysql

replace

0 556 posted 9 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 725 posted 9 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 624 posted 9 years ago by apphp-snippets

MySQL MySQL Event scheduler

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

mysql

0 580 posted 9 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.