ubuntuforums-unanswered team mailing list archive

Thread
Date

Re: [Question #76481]: insert query in Open office

To: ubuntuforums-unanswered@xxxxxxxxxxxxxxxxxxx
From: Tony Pursell <question76481@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 10 Jul 2009 22:20:17 -0000
Reply-to: question76481@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

Question #76481 on openoffice.org in ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/76481

    Status: Open => Answered

Tony Pursell proposed the following answer:
Hi Gautam

The general format for a simple SQL insert query is

INSERT INTO "table" ("col1_name","col2_name",...) VALUES
(value_for_col1,value_for_col2,...)

The values must be given in a valid way for HSQLDB. For a VARCHAR that
would be a string in quotes.  I'm not sure about other data types.  You
might have to experiment.  HSQLDB likes all its table and column names
in quote - I think you know that already.

Instead of a VALUES statement, you can have a SELECT statement, in which
case, everything selected is inserted in to the table.

Tony

-- 
You received this question notification because you are a member of UF
Unanswered Posts Team, which is an answer contact for Ubuntu.