Dreamweaver - Mysql and Windows?

Author

Mysql and Windows?

DRAGON

2004-06-02, 11:16 pm

Dear all,

Following are my questions:

1. Can mysql work with Windows? How can be configured?
2.Can anybody give me a site that gives examples with mysql databases?
3. What is the genral opinion of My SQL?

Regards

Introspective

2004-06-02, 11:16 pm

DRAGON wrote:
> Dear all,
>
> Following are my questions:
>
> 1. Can mysql work with Windows? How can be configured?
> 2.Can anybody give me a site that gives examples with mysql databases?
> 3. What is the genral opinion of My SQL?
>
> Regards
>
>

1. yes, you can download the windows binaries from mysql.com or a mirror
2. google is your friend >
http://www.google.com/search?&q=mys...ple%20databases
3. personally, i like it. its always a matter or personal preference,
some people hate mysql, and use postgresql, or mssql

David B

2004-06-02, 11:16 pm

DRAGON wrote:

> Dear all,
>
> Following are my questions:
>
> 1. Can mysql work with Windows? How can be configured?
> 2.Can anybody give me a site that gives examples with mysql databases?
> 3. What is the genral opinion of My SQL?

MySQL and PHP are one of the hottest combinations on the Internet and
are often combined with the Apache server. I can't compare mysql to
other database software, as I've only used mysql - and I'm still a beginner.

But server side languages (like PHP) and databases (MySQL) are awesome.
One of my biggest regrets is that I waited so long to take the plunge.
It is a steep learning curve; expect to spend weeks getting it installed
and configured and learning the basics. But the results are worth it.

Rather than installing and configuring mysql separately, some people
download preconfigured packages that include PHP, mysql and Apache. I
found a good one from a German operation called Apache Friends. With my
setup, Apache runs automatically in the background; it turns on and off
with my computer. I double click a couple icons to start and stop MySQL.

Rather than offer an example, let me explain what you can do with MySQL.
Imagine that you have a huge database with three tables of data focusing
on Nations, States and Counties. Each table has a field (column) with
the names of all the nations, states and counties, followed by their
capitals, population, size, etc.

Obviously, you can't display three tables, with over 3,000 rows and
thirty columns combined. But with PHP and MySQL, you can display certain
portions of those tables. For example, you can display a table that
features only Texas counties, and you can further reduce it to just four
columns, like name, capital, population and area. You can also "join"
tables. For example, visitors to one of your pages might see a table
featuring all the U.S. counties whose county seats are also state
capitals. By "joining" the state and counties tables, you could also
include a column with the names of the states. Or you could join a
Nations table and a Continents table, so that every nation that the
United States, Argentina, Nepal and Tanzania (Nations table) also
display their continents' highest mountain peaks (Continents) table.

You can also use "databases" to drive websites, though I haven't learned
how to do that yet. Let's say you have a database that includes columns
with state names, nicknames and capitals, and it also includes fields
with articles about each state.

You could put some code in the top of each page identifying that page as
Alaska, Nebraska, etc., and that page would automatically display the
proper name, nickname and capital, followed by the appropriate article.

There are lots more really cool things you can do with MySQL. By the
way, you'll want to check out a variety of software designed for working
with MySQL. phpMyAdmin is the standard, but there are others, both
freeware and commercial, that can come in handy.