sql to do CSV export from MySQL

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?

Re: sql to do CSV export from MySQL

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.