nnichols questions

nnichols answers

• Remove Duplicate Records Except One Record
• Checking for maximum length of consecutive days which satisfy specific condition
• Transpose mysql query rows into columns
• How can I optimize MySQL query for update?
• Innodb & Temporary tables
• mysql "not a variable or NEW pseudo-variable" message
• How does MySQL fulltext search work?
• how to count rows by first letter?