sql to do CSV export from MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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:
Quoted text here. Click to load it

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.

Site Timeline