Ask Your Question
1

What websites have good examples of SQL queries for Base? [closed]

asked 2012-08-12 03:42:20 +0200

mrmister gravatar image

updated 2013-01-30 09:11:08 +0200

qubit gravatar image

If you please, could recommend me any cool website where I can get examples of code, and the syntax of the SQL language explained for dummies (loool sorry) I really would appreciate that.

As far as I know Base use HyperSQL and not SQL? not sure?

I just want to start to create SQL queries, but always I type some lines of code I get an error message, so I need a website explaining this for Base. Would you recommend me any?

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-09 04:14:13.368326

2 Answers

Sort by » oldest newest most voted
2

answered 2012-08-12 14:18:42 +0200

tohuwawohu gravatar image

updated 2012-08-13 14:08:59 +0200

For a beginner, the SQL Wikibook may be a good point to start. To start learning SQL, it may be better not to use base, because Base has its own interface and concepts - you may be better off starting with a very simple SQL environment, maybe even text-based (no GUI).

HyperSQL (or HSQLDB) is the name of the default database engine. The features page describes the SQL standards and features supported. You don't need those details when starting with SQL.

BTW: Please don't use the subject line to ask the complete question - just put a short summary there.

EDIT:

Most Base tutorials aim at OpenOffice Base, but you can use them to get acquainted with LO Base, too. Some of them are:

edit flag offensive delete link more
0

answered 2012-08-13 12:04:35 +0200

mrmister gravatar image

I understand, but I need to use Base because I am working in several videotutorials about Base, the idea I have is the public government here, use Base and LibreOffice extensively, so I am tackling several videotutorials about it. Although I used to program in Pascal years ago, I don't know a word of SQL so I would like to start with some basic commands and some basic stuff, but inside Base. As far as I understand your reply, Base is using SQL language, so what I would need is some basic introduction to SQL in Base, basic things as the Hello World stuff in programming, but to retrieve some information from my current table and stuff like that. I've read the SQL Wikibook but I still continue finding it a bit complex... :(

edit flag offensive delete link more

Comments

Ok - i've added two links pointing to base-related resources.

tohuwawohu gravatar imagetohuwawohu ( 2012-08-13 14:09:43 +0200 )edit

Question Tools

Stats

Asked: 2012-08-12 03:42:20 +0200

Seen: 5,775 times

Last updated: Sep 19 '13