sql to do CSV export from MySQL

[GSP]

Does anyone know what sql would generate a CSV file from MSQL? As instructed
by the help file I've tried;

CREATE TABLE tablename ( tabledefinition here) ENGINE = CSV

when I execute this sql I get 'No database selected'! If this would actually
create the table I should then be able to;

INSERT INTO tablename SELECT remaider of sql select statement here.

Any ideas on this?

[Aggro]

GSP@DCS wrote:

Does anyone know what sql would generate a CSV file from MSQL? As instructed
by the help file I've tried;

CREATE TABLE tablename ( tabledefinition here) ENGINE = CSV

when I execute this sql I get 'No database selected'! If this would actually
create the table I should then be able to;

You need to select database before you commit that query. If you don't
have any databases, you need to create one first. For example:

create database mydatabase;

And use it with command:

use mydatabase;

After succesful use-command, you can give create table and insert queries.