Welcome To Snipplr


Everyone's Recent SQL Snippets



1 ... 11 12 13 14 15 ... 18
0 905 posted 15 years ago by tvanzele
0 1068 posted 15 years ago by tvanzele
1 929 posted 15 years ago by tvanzele
1 861 posted 15 years ago by tvanzele
1 875 posted 15 years ago by tvanzele
0 796 posted 15 years ago by tvanzele
I found this and simply want to store it. It was done by Valentino Vranken
2 3350 posted 15 years ago by ezerick
0 909 posted 15 years ago by hubertd
creates a user that has only access to one database, from any host
1 1415 posted 15 years ago by manuelstofer
Create a new utf8 database in MySQL
1 1067 posted 15 years ago by manuelstofer
Here's a handy query for finding duplicates in a table.
3 1231 posted 15 years ago by jmiller
1 1025 posted 15 years ago by sennesaelium
I had several vocabularies but wanted to merge them into one. A simple query does this for you. The vocabulary_id where I wanted to merge all the tags into is 3 The vocabulary_id where the tags are to be merged from is 7, 8 and 12
2 1246 posted 15 years ago by berkes
1 1002 posted 15 years ago by CDIDevs
1 1233 posted 15 years ago by CDIDevs
Re-seed identity table if rows were deleted/there are gaps in numerical order
2 970 posted 15 years ago by CDIDevs
1 1196 posted 15 years ago by CDIDevs
2 1122 posted 15 years ago by CDIDevs
1 1077 posted 15 years ago by CDIDevs
Just replace the squared brackets with the correct values.
1 1452 posted 15 years ago by choasis
2 1008 posted 15 years ago by czapata
Perform a search of all user tables in the current database to locate a column defined in a user table that matches a certain name. The first query looks for an exact column name and the second one returns all column names which match a keyword (usi...
1 1440 posted 15 years ago by kencyber
Searches the code for all functions in the current database and returns results containing the function name, the character index where the first match was found, and a portion of the code where the match occurred.
1 1216 posted 15 years ago by kencyber
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 1728 posted 15 years ago by zingo
Reset joomla super admin password to ”admin“
1 967 posted 15 years ago by elisium
A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table. Don't forget to Drop the table after the SELECT * FROM #TempTableName at the end.
2 1563 posted 15 years ago by highlyevolved
These statements convert a date/time field into just a date or a time field
2 1389 posted 15 years ago by highlyevolved
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 1201 posted 15 years ago by tobewan
1 ... 11 12 13 14 15 ... 18