Advanced Search

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged mysql

1 594 posted 14 years ago by jmacgr
Esquema basico manejo cursores en MYSQL
0 494 posted 14 years ago by xaviles
0 523 posted 14 years ago by level09
Some code I found for calculating and determining a persons age
1 517 posted 14 years ago by mpcircuitry
Came across this nice snippet @ mysql.com
2 2795 posted 14 years ago by j4kp07
used to find content that uses the PHP input filter....useful for upgrading core!
0 690 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
1 683 posted 14 years ago by nate63179
- 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
1 550 posted 14 years ago by nkm
Remove <>
0 749 posted 14 years ago by jodm
Used to make sure the server log dose not fill up the hd.
2 587 posted 14 years ago by mushookies
0 942 posted 14 years ago by CuDDL
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 572 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
CLI commands for backing up mySQL database
2 827 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
2 693 posted 15 years ago by craig1709