Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it extremely simple:

CREATE TABLE moo3 (id_1 INT, name_1 VARCHAR(255));

Now the query seems to be executed, returning no results, but I can't find the table in Base's GUI. Is it a bug or am I doing it wrong?

share|improve this question
add comment

1 Answer

You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.