paul-turner.net

Saving the results of a MySQL query in a format that Excel can use

Here’s the syntax for creating a UTF-8 database in MySQL as I can never remember it!

CREATE DATABASE `databasename` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;