Learning MySQL

Learning MySQL

am 05.09.2007 09:03:47 von Blue_Hat

I'm new to the world of programming and all, what I would like to know
is how to create MySQL databases and resources that would help an
aspiring programmer like myself at getting the hang of the whole world
of MySQL, I love the idea of writing dynamic websites and such are ther
like editors for MySQL databases? I am like totally clueless

Re: Learning MySQL

am 05.09.2007 18:25:27 von Shion

Blue_Hatter wrote:
> I'm new to the world of programming and all, what I would like to know
> is how to create MySQL databases and resources that would help an
> aspiring programmer like myself at getting the hang of the whole world
> of MySQL, I love the idea of writing dynamic websites and such are ther
> like editors for MySQL databases? I am like totally clueless

Much depends on what you call "editor", there are quite many different tools
that you can "edit" with.

1. Database administration (mysql-administrator)
These tools allow you to easilly "edit" the settings for the database server

2. Query browsers (mysqlnavigator, mysql-query-browser)
These tools give you a frontend to communicate with your database

3. IDE (KDevelop)
Allows you to develop software and has syntax coloring, so you can see
easily if you done things right or not


If you want to make dynamic web pages, but not spend the time to learn SQL and
PHP, then you have a load of CMS projects at freshmeat.net that you can use.

--

//Aho

Re: Learning MySQL

am 09.09.2007 22:27:49 von esoterik

On Wed, 05 Sep 2007 02:03:47 -0500, Blue_Hatter wrote:

> I'm new to the world of programming and all, what I would like to know
> is how to create MySQL databases and resources that would help an
> aspiring programmer like myself at getting the hang of the whole world
> of MySQL, I love the idea of writing dynamic websites and such are ther
> like editors for MySQL databases? I am like totally clueless


I would grab a cheap webhost (cpanel type, few bucks a month) and play
around with it. If youre on windows, you can grab a copy of Xampp which is
an all in one apache/mysql/php/curl release that is pretty easy to work
with.

The reason I liked starting with these was phpMyadmin made it easy to
check out what my scripts were doing to the database, and it wasnt
intimidating like working on a command line. Leafing through a few books
at the bookstore also helped to make sense of the more complex ides too..

-eso