Advanced Search

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged mysql

1 2 3 4 5 6 Next »
Add an attribute to existing table
1 727 posted 15 years ago by marouanomezzine
When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.
4 667 posted 15 years ago by jdbartlett
Show table size, number of rows, and size of indexes in MySQL.
1 950 posted 15 years ago by zingo
I currently have project_issue nodes set for replacement pattern issues/issue[nid] in Drupal 5.x PathAuto. This query fixes all of the URL aliases for entries created before this was set correctly.
0 563 posted 15 years ago by tgbdad
1 492 posted 15 years ago by ping_ch
Some other alter syntax examples at the URL, which beats the pants off the MySQL manual for some reason.
0 639 posted 15 years ago by tclancy
0 677 posted 15 years ago by sebus
1 760 posted 16 years ago by tclancy
1 2 3 4 5 6 Next »