Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- sql to do CSV export from MySQL
May 26, 2006, 12:17 pm
rate this thread
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
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:
After succesful use-command, you can give create table and insert queries.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum