Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged mysql

« Prev 1 2 3 Next »

SQL Remove trailing newlines from database fields

sometimes we botch an import, and end up with return or newline characters in the field. So fields which should be empty have \r in them, or fields with text data have an invisible trailing newline. This makes it impossible to match the text values....

mysql

0 591 posted 13 years ago by powerthru

SQL Select Duplicates

mysql

1 533 posted 13 years ago by traeregan

SQL Select Records Beginning With Certain Letter

mysql

1 575 posted 13 years ago by traeregan

SQL Remove duplicate entries / rows from mySQL

This is the quick method and painless way to Remove duplicate entries from MySQL

mysql

2 671 posted 13 years ago by lixonic

SQL MySQL Blob Compression performance query

mysql

0 513 posted 13 years ago by j4kp07

SQL mysql query to populate table from data in file

mysql

0 848 posted 13 years ago by breign

SQL Search & Replace in MySQL DB

SQL to alter field contents. linked article is in german.

mysql

1 795 posted 13 years ago by iroybot

SQL Mysql: Change User Password

Change a user password

mysql

0 574 posted 14 years ago by manuelstofer

SQL SQL: Create a user that has only access to one database

creates a user that has only access to one database, from any host

mysql

1 835 posted 14 years ago by manuelstofer

SQL Dump Table Data into CSV

mysql

2 574 posted 14 years ago by czapata

SQL Calculating distance in Kilometres and Miles from Latitude and Longitude

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

mysql

3 966 posted 14 years ago by zingo

SQL Importing a MySQL database in Windows

mysql

1 723 posted 14 years ago by Mithun

SQL Find all databases and login credentials

If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:

mysql

1 706 posted 14 years ago by tobewan

SQL CodeIgniter Session Table SQL

mysql

4 723 posted 14 years ago by pdswan

SQL Select random row from a SQL database.

This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.

mysql

1 622 posted 15 years ago by xtheonex

SQL Duplicate or clone one or more rows in MySQL

mysql

1 2385 posted 15 years ago by gfazioli

SQL get random record from mysql

get some random record from mysql quicklyã€‚

mysql

0 652 posted 15 years ago by liuran

SQL Select the primary key for a table

mysql

0 647 posted 15 years ago by jachin

SQL mysql php get enum values

mysql

0 688 posted 15 years ago by ginoplusio

SQL MYSQL add counter in query

mysql

1 636 posted 15 years ago by ginoplusio

SQL MySQL disable foreign key constraint check

mysql

1 628 posted 15 years ago by pointer

SQL MySQL reset autoindex

mysql

1 397 posted 15 years ago by ericserrat

SQL Sort results by order in list

mysql

0 936 posted 15 years ago by Wardy

SQL update a field in mysql

mysql

0 606 posted 15 years ago by therobot

SQL Change user password in mediawiki

mysql

0 595 posted 15 years ago by hdanniel

SQL 50 States & Washington D.C.

Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.

mysql

1 568 posted 15 years ago by simplistik

SQL Delete Dulicate Rows in MySQL

Where bad_table is the name of the table containing duplicate rows.

mysql

2 433 posted 15 years ago by jdbartlett

SQL MySQL Find and Replace Drupal filepaths in files table

This is useful if you are changing a Drupal site's file upload path and/or changing from a private to a public file store.

mysql

3 1450 posted 15 years ago by shrop

SQL Importing data from (Excel) CSV into MySQL

Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.

mysql

4 901 posted 15 years ago by jarnaldich

SQL MySQL Table - US States

This will create and then populate a MySQL table with a list of the names and USPS abbreviations for US states and possessions in existence.

mysql

3 2629 posted 15 years ago by cbrant

« Prev 1 2 3 Next »