Welcome To Snipplr
Everyone's Recent MySQL Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Some code I found for calculating and determining a persons age
1
517
posted 14 years ago by mpcircuitry
used to find content that uses the PHP input filter....useful for upgrading core!
0
689
posted 14 years ago by ReeceMarsland
Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!
0
610
posted 14 years ago by beneberle
- fields on db with utf8_general_ci collation
- make this query after any connection
- put meta charset utf8
- read and write strings without problems
0
583
posted 14 years ago by ginoplusio
Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.
1
730
posted 14 years ago by BFTrick
MySQL Insert Unique Reference using MAX() to obtain latest value
Alternate solution to using Composite Primary Keys which INNODB engine does not support.
0
598
posted 14 years ago by cherbert
This script shows the top 10 worst indexes (in terms of selectivity %) on the whole MySQL server instance. Selectivity is the percentage of distinct values in an indexed field compared to the number of records in the table.
Note that this query can...
1
571
posted 14 years ago by Eloi
This will create and then populate a MySQL table with a list of the names for countries in existence. Country names are in Turkish language.
0
1023
posted 14 years ago by sensimevanidus
granting DB specific and general access priveleges from the CLI
1
690
posted 14 years ago by stiobhart
Splitting table users in frequently and infrequently accessed attributes
2
999
posted 14 years ago by Eloi
Saving the IP as Int we save a lot of space and permit do beautibul selects
2
640
posted 14 years ago by Eloi