Welcome To Snipplr


Everyone's Recent MySQL Snippets



« Prev 1 2 3 4 5 ... 8
  1. FAV

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

    A request to clear a single column in a table / MySQL /
    MySQL 50 views posted 4 months ago by cerxx
  2. FAV

    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 3 views posted 1 year ago by surentharp
  3. FAV

    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 7 views posted 2 years ago by apphp-snippets
  4. FAV

    Configuration Mysql 5.7

    Some configurations for mysql 5.7
    MySQL 6 views posted 2 years ago by ironcrema
  5. FAV

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

    Show the output of a query in a more readable vertical format
    MySQL 5 views posted 3 years ago by rm1984
  6. FAV

    Update password in Liferay Portal from db

    Thanks to Paras Jain
    MySQL 5 views posted 4 years ago by yhauxell
  7. FAV

    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...
    MySQL 4 views posted 4 years ago by bvwatson
  8. FAV

    Mysql - Convertir todas las columnas en colación utf8

    Consulta que permite convertir todas las tablas en colación utf8
    MySQL 5 views posted 4 years ago by ironcrema
  9. FAV

    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
    MySQL 6 views posted 5 years ago by jacktan
  10. FAV

    Mysql find duplicate values in field

    Mysql find duplicate values in field
    MySQL 4 views posted 5 years ago by flatearthcomms
  11. FAV

    Delete from table with limit (mySQL)

    Delete from table with limit (mySQL)
    MySQL 5 views posted 5 years ago by Kcko
  12. FAV

    consulta mysql count having

    query with count having
    MySQL 6 views posted 5 years ago by ironcrema
  13. FAV

    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 3 views posted 5 years ago by imbraz
  14. FAV

    Project Management Database Setup Script

    Sets up the database for my project management software (in development - C#)
    MySQL 7 views posted 5 years ago by JordanRowles
  15. FAV

    Add current date to date field that is null

    MySQL 3 views posted 5 years ago by jlmarks
  16. FAV

    get list of all values in a field MySQL

    MySQL 5 views posted 5 years ago by jlmarks
  17. FAV

    Replace String MySql

    Replace string mysql
    MySQL 6 views posted 5 years ago by ironcrema
  18. FAV

    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 5 views posted 6 years ago by apphp-snippets
  19. FAV

    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 5 views posted 6 years ago by apphp-snippets
  20. FAV

    MySQL Event scheduler

    This post will explain you the use of Event scheduler in MySQL.
    MySQL 8 views posted 6 years ago by kp32
  21. FAV

    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 10 views posted 6 years ago by donkeykong
  22. FAV

    Agregar LLave Foránea MySql

    Convierte un campo de una tabla a llave foránea
    MySQL 3 views posted 6 years ago by ironcrema
  23. FAV

    Modify Column for Table Of Mysql

    Modify Column for Table Of Mysql
    MySQL 6 views posted 6 years ago by lyroge
  24. FAV

    Drop and Add Column for Table of Mysql

    Drop and Add Column for Table of Mysql
    MySQL 5 views posted 6 years ago by lyroge
  25. FAV

    Drop and Add Index for Table of Mysql

    Drop and Add Index for Table of Mysql
    MySQL 3 views posted 6 years ago by lyroge
  26. FAV

    Find duplicate mysql field vale

    Prints out a list of any field containing duplicates with count
    MySQL 11 views posted 6 years ago by flatearthcomms
  27. FAV

    MySQL_reset_root_pass

    Reset MySQL root password
    MySQL 4 views posted 6 years ago by Aminreza
  28. FAV

    gunzip mysql import/export

    Import/export gunzipped compressed mysql database
    MySQL 5 views posted 6 years ago by tzvio
  29. FAV

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

    Le fonction COALESCE de MySQL permet de renvoyer une valeur par défaut si la valeur null est renvoyée initialement.
    MySQL 2 views posted 7 years ago by pruntrut
  30. FAV

    [MySQL] Add condition to Virutal Fields

    By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT
    MySQL 5 views posted 7 years ago by tucq88
« Prev 1 2 3 4 5 ... 8