Re: postgresql
- From: Frank Ranner <franner@xxxxxxxxxxxxxxxxxxxx>
- Date: 29 Mar 2007 11:00:45 GMT
On Wed, 28 Mar 2007 01:43:27 -0700, Tavanda Kosan wrote:
hello
i want to run some sql and postgresql commands.. i installed mysql and
postgresql from yast.. but i dont know where i can create tables or
users.. i just want to make some practise for my sql lecture. i want
to run some basic statement like `select fname,lname from users where
salary=500` and so on...
Assuming you have installed postgresql-docs to can point your browser to:
file:///usr/share/doc/packages/postgresql/html/index.html
For mysql, there is an excellent 1960 page manual in
/usr/share/doc/packages/mysql/manual.pdf
But the fact remains, these are complex packages which require some
administrator skills to even get started. If you just want to play with
select, insert and update commands then sqlite3 is ideal.
# sqlite3 pets.sq3
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> create table animal (name, legs);
sqlite> insert into animal values ('dog',4);
sqlite> select * from animal;
dog|4
sqlite> .dump
BEGIN TRANSACTION;
CREATE TABLE animal (name,legs);
INSERT INTO "animal" VALUES('dog', 4);
COMMIT;
sqlite3 stores everything in a single file, that you can copy or mail.
There is no server, no admin required. There are also modules available
for perl and tcl/tk to do scripting with sqlite databases.
Good luck,
--
Frank Ranner
.
- References:
- postgresql
- From: Tavanda Kosan
- postgresql
- Prev by Date: Re: ./configure command
- Next by Date: Monitor won't power off
- Previous by thread: Re: postgresql
- Next by thread: Re: postgresql
- Index(es):
Relevant Pages
|
