hbhh 26 Eki 2013 08:48 tarihinde "Neil Mancini" <[email protected]> yazdı: > > 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 : >> >> ------------------------------------------------------ >> >> = 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. h
-- 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.
