New to MySQL

[Murphy]

I have installed MySQL under Linux and it's now running...

I have created a DB and a few tables and populated them...

How do I query the tables now ? I have enter SQL statements at the command
prompt however some are quite complex and surely don't have to be reentered
every time ?

I found a package called "query browser" but to date have been unable to get
it to work... is this the correct package for executing queries on the db ?

I am migrating from SQL Server where I could use stored procedures and views
however I understand these are still in development and to be realeased in
version 5.

--
Thanks

Murph

[steve]

Re: New to MySQL

"Murphy" wrote:[color=blue]
>I have installed MySQL under Linux and it’s now running...
>
>I have created a DB and a few tables and populated them...
>
>How do I query the tables now ? I have enter SQL statements at the
>command
>prompt however some are quite complex and surely don’t have to
>be reentered
>every time ?
>
>I found a package called "query browser" but to date have been[/color]
unable[color=blue]
>to get
>it to work... is this the correct package for executing queries on[/color]
the[color=blue]
>db ?
>
>I am migrating from SQL Server where I could use stored procedures[/color]
and[color=blue]
>views
>however I understand these are still in development and to be
>realeased in
>version 5.
>[/color]

mysql does not have the views and stored procedures.. it is a simpler
db.

You use phpmyadmin to interact with the db (easier than using prompt).
It is kind of equiv. to sql server’s Enterprise Manager.

I would buy a nice introductory book...

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-defaul...ict212313.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=741484