Welcome To Snipplr


Everyone's Recent MySQL Snippets Tagged mysql



0 960 posted 14 years ago by erraja_07
Go to the Windows command line by going to Start -> Run and typing in cmd. You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin. Therefore, the command to change to this dire...
0 1014 posted 14 years ago by TheJasonParker
0 915 posted 14 years ago by takel
0 925 posted 14 years ago by dsoms
1 937 posted 14 years ago by yanek1988
0 886 posted 14 years ago by sjacunningham
With this snipt you could replace all the "<br>" tags that you have in a table for php newline character.
0 1290 posted 14 years ago by tonatiuh
0 1139 posted 14 years ago by BoNzO
3 1224 posted 14 years ago by nielsenrc
If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes, then this might help. You also need to make sure that the user that you log in with has SUPER privileges on their account.
0 1040 posted 14 years ago by daipratt
0 960 posted 14 years ago by xnet74
the following code can be used to create a table with a dynamic name
0 1037 posted 14 years ago by gtaking
Use this to repair a corrupt table in phpmyadmin
0 955 posted 14 years ago by howardpanton
0 937 posted 14 years ago by sjacunningham
0 955 posted 14 years ago by luglio7
Convert a Drupal time stamp field into a readable format. The Drupal time stamp field is in the UNIX format.
1 1279 posted 14 years ago by daipratt
How to reset a root password in mysql with OS root user
0 966 posted 14 years ago by isholgueras
How to reset a root password in mysql with OS root user
0 949 posted 14 years ago by isholgueras
Use this to select all fields between two different dates
0 971 posted 14 years ago by howardpanton
0 920 posted 14 years ago by hamsterbacke82
2 1167 posted 14 years ago by cjmling
When working on client sites, you often need admin access, instead of requiring them to set up an admin user, just make your own. ref: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database
2 1345 posted 14 years ago by timkinnane
If you\'ve got a Wordpress install that\'s changed domain or you\'re making a local or development copy, you\'ll need to update the Wordpress DB tables with the new URL.\r\nThe first step is the options table, with siteurl and homeurl. The posts als...
1 1044 posted 14 years ago by timkinnane
Group by user defined price bands.
1 2544 posted 14 years ago by daipratt
for auto increment ids, when you delete records this will reset the number for the next auto id.
0 1015 posted 14 years ago by matula
3 1178 posted 14 years ago by matula
5 1144 posted 14 years ago by matula