Re: download SQL under Solaris10 x86

On Fri, 30 Nov 2007, happytoday wrote:

> I need to learn and download an SQL under Solaris10 x86 version from
> where can I begin (What version is easier to have and learn)?

No need to download anything: Solaris ships with Postgres and
MySQL "in the box". :-)

--
Rich Teer, SCSA, SCNA, SCSECA, OGB member

CEO,
My Online Home Inventory

URLs: http://www.rite-group.com/rich
http://www.linkedin.com/in/richteer
http://www.myonlinehomeinventory.com

Re: download SQL under Solaris10 x86

bsh writes in comp.unix.solaris:
|Rich Teer wrote:
|> happytoday wrote:
|> > I need to learn and download an SQL under Solaris10 x86 version from
|> > where can I begin (What version is easier to have and learn)?
|> No need to download anything: Solaris ships with Postgres and
|> MySQL "in the box". :-)
|
|... And for the second alternative, I reiterate Celko's (another
|name which will become eventually familiar to you) advice of
|preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
|Postgres and go directly to PostgreSQL, its opensource and
|standards compliant modern SQL implementation.

PostgreSQL is the one that's actually bundled into Solaris.

--
Alan Coopersmith * alanc@alum.calberkeley.org * Alan.Coopersmith@Sun.COM
http://blogs.sun.com/alanc/ * http://people.freedesktop.org/~alanc/
http://del.icio.us/alanc/ * http://www.csua.berkeley.edu/~alanc/
Working for, but definitely not speaking for, Sun Microsystems, Inc.

Re: download SQL under Solaris10 x86

In alt.solaris.x86 Alan Coopersmith wrote:
> bsh writes in comp.unix.solaris:
> |Rich Teer wrote:
> |> happytoday wrote:
> |> > I need to learn and download an SQL under Solaris10 x86 version from
> |> > where can I begin (What version is easier to have and learn)?
> |> No need to download anything: Solaris ships with Postgres and
> |> MySQL "in the box". :-)
> |
> |... And for the second alternative, I reiterate Celko's (another
> |name which will become eventually familiar to you) advice of
> |preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
> |Postgres and go directly to PostgreSQL, its opensource and
> |standards compliant modern SQL implementation.
>
> PostgreSQL is the one that's actually bundled into Solaris.
>
Sqlite 2.8 is available in Sol10 as /lib/svc/bin/sqlite

Re: download SQL under Solaris10 x86

On Mon, 3 Dec 2007, bsh wrote:

> While Mr. Teer's reputation preceeds him, I venture the hubris
> to add a caveat for one presuming to learn SQL/RDBMS: I
> recommend that you _either_ commit to learning canonical SQL
> (if such as thing can be said to exist!), or accept the

Good advice.

> preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
> Postgres and go directly to PostgreSQL, its opensource and
> standards compliant modern SQL implementation.

Umm, Postgres *is* PostgreSQL (the former being a common
abbreviation for the latter)! Being SQL-compliant is one
of the reasons why I recommend it over MySQL...

--
Rich Teer, SCSA, SCNA, SCSECA, OGB member

CEO,
My Online Home Inventory

URLs: http://www.rite-group.com/rich
http://www.linkedin.com/in/richteer
http://www.myonlinehomeinventory.com

Re: download SQL under Solaris10 x86

happytoday wrote:
> On Dec 4, 6:55 pm, Rich Teer wrote:
>> On Mon, 3 Dec 2007, bsh wrote:
>>> While Mr. Teer's reputation preceeds him, I venture the hubris
>>> to add a caveat for one presuming to learn SQL/RDBMS: I
>>> recommend that you _either_ commit to learning canonical SQL
>>> (if such as thing can be said to exist!), or accept the
>> Good advice.
>>
>>> preferable RDBMSs: Teradata, Mimer, or Ocelot. Or: skip
>>> Postgres and go directly to PostgreSQL, its opensource and
>>> standards compliant modern SQL implementation.
>> Umm, Postgres *is* PostgreSQL (the former being a common
>> abbreviation for the latter)! Being SQL-compliant is one
>> of the reasons why I recommend it over MySQL...
>>
*For goodness sake, stop quoting signatures!*
>
> can any body advice me of simple SQL programs of how can I create a
> table and insert some records into it written using SQL code .
> Thanks

Just type it in, or learn a scripting language like PHP.

--
Ian Collins.

Re: download SQL under Solaris10 x86

On Mon, 24 Dec 2007, happytoday wrote:

> can any body advice me of simple SQL programs of how can I create a
> table and insert some records into it written using SQL code .

Read a book on SQL and database programming.

But as it's Xmas, here's a snippet:

create table people
(
id serial,
name varchar (128) not null.
age int not null,
primary key (id)
);

insert into people (name, age) values values ('Rich Teer', 40);

HTH,

--
Rich Teer, SCNA, SCSA, SCSECA, OpenSolaris CAB member

. * * . * .* .
. * . .*
President, * . . /\ ( . . *
Rite Online Inc. . . / .\ . * .
.*. / * \ . .
. /* o \ .
* '''||''' .
URL: http://www.rite-group.com/rich ******************

Re: download SQL under Solaris10 x86

happytoday wrote:
>
> How can I compile SQL program ?
>
> I habe done this with the below error :
>
> # /usr/sfw/bin/mysql sql001
> ERROR 2002: Can't connect to local MySQL server through socket '/tmp/
> mysql.sock' (2)
> #

I think you have to read up on SQL and what a database is first.
Take a look here http://dev.mysql.com/doc/

The /usr/sfw/bin/mysql command lets you log into the database engine and
start running SQL code. If you have the code in a file 'sql1001' then
inside the database you can do like this:

http://dev.mysql.com/doc/refman/5.1/en/batch-mode.html