Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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....
0
1357
posted 15 years ago by powerthru
This is the quick method and painless way to Remove duplicate entries from MySQL
2
1459
posted 15 years ago by lixonic
creates a user that has only access to one database, from any host
1
1653
posted 15 years ago by manuelstofer
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.
3
2138
posted 16 years ago by zingo
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:
1
1414
posted 16 years ago by tobewan
This is by no means the most efficient way to do this, in terms of performance.
It is however the easiest way.
1
1453
posted 16 years ago by xtheonex
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
1
1218
posted 17 years ago by simplistik
Where bad_table is the name of the table containing duplicate rows.
2
1110
posted 17 years ago by jdbartlett
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.
3
2563
posted 17 years ago by shrop
Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.
4
1981
posted 17 years ago by jarnaldich
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.
3
4000
posted 17 years ago by cbrant