Welcome To Snipplr
Everyone's Recent MySQL Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
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
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
the following code can be used to create a table with a dynamic name
0
1037
posted 14 years ago by gtaking
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
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
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