Skip to content
Rodgers Notes
Rodger Lepinsky, Database Expert, Data Analyst, Data Scientist.
  • Data Modeling
    • testpage_4
  • Database Tuning
  • Database Administration
  • Blog
  • Contact
    • About Rodger Lepinsky

Category: SQL

MYSQL – Create CSV File With Fieldnames For Headers

October 19, 2014 Rodgers Notes Writer 2 Comments

How to export a MYSQL table into a CSV file, with the fieldnames in the first row. In one simple MYSQL command.

Continue Reading →

Posted in: SQL Filed under: csv, MYSQL, Unix and Linux

Why I Like The Merge Statement

November 22, 2010 Rodgers Notes Writer Leave a comment

Over the past few years, I’ve stopped using the Update statement, and  started using the Merge statement for updates instead. …

Continue Reading →

Posted in: SQL Filed under: Analysis, Merge
  • Architecture
  • Cartesian Products
  • Data Science
  • Database Design Mistakes to Avoid
  • Design
  • Graph Database
  • Humour
  • Oracle Applications
  • Oracle DBA Subjects
  • Power Scripts
  • Quality
  • R
  • Reviews
  • Science
  • Security
  • SQL
  • SQL Server
  • Tuning
  • Uncategorized
  • Uniface
  • Unix and Linux
  • Windows
Copyright © 2025 Rodgers Notes — Velux WordPress theme by GoDaddy