Hi,
> where should the 'test.csv' be stored ?
This is the same as for "java.io.File". If you use CSVREAD('test.csv'),
then the file needs to be in the current working directory. But of course
you can use an absolute path.
Regards,
Thomas
On Sat, Oct 26, 2013 at 5:17 AM, Neil Mancini <[email protected]> wrote:
> where should the 'test.csv' be stored ?
>
>
> On Friday, May 28, 2010 12:50:20 PM UTC-4, Thomas Mueller wrote:
>>
>> Hi,
>>
>> I will add the following documentation at
>> http://h2database.com/html/**tutorial.html#csv<http://h2database.com/html/tutorial.html#csv>:
>>
>> ------------------------------**------------------------
>>
>> = Importing Data from a CSV File =
>>
>> A fast way to load or import data (sometimes called 'bulk load') from
>> a CSV file is to combine table creation with import. Optionally, the
>> column names and data types can be set when creating the table.
>> Another option is to use INSERT INTO ... SELECT.
>>
>> CREATE TABLE TEST AS SELECT * FROM CSVREAD('test.csv');
>> CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255))
>> AS SELECT * FROM CSVREAD('test.csv');
>>
>> ------------------------------**------------------------
>>
>> Does this solve your problem?
>>
>> Regards,
>> Thomas
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
>
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
