New MySQL InStall

--_55b12d3c-f2a0-43df-b8bb-4cbbb1dc34db_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Can anyone give me some info here.... I want to install MySQL on a Vista H=
ome Edition Laptop.... Can anyone tell me what I should download from the =
site? I want to run a java app..... What version is stable and does it ma=
tter the operating system? Thank-You Mike =20
____________________________________________________________ _____
Win $10=2C000 from Hotmail! Enter Here.
http://go.microsoft.com/?linkid=3D9729708=

--_55b12d3c-f2a0-43df-b8bb-4cbbb1dc34db_--

Re: New MySQL InStall

--00c09fc2bee79283e6048603061b
Content-Type: text/plain; charset=ISO-8859-1

You can dowload the community server here:

http://dev.mysql.com/downloads/mysql/

---
Weydson Lima
weyseal@gmail.com


On Thu, May 6, 2010 at 12:59 PM, Michael Abbott wrote:

>
> Can anyone give me some info here.... I want to install MySQL on a Vista
> Home Edition Laptop.... Can anyone tell me what I should download from the
> site? I want to run a java app..... What version is stable and does it
> matter the operating system? Thank-You Mike
> ____________________________________________________________ _____
> Win $10,000 from Hotmail! Enter Here.
> http://go.microsoft.com/?linkid=9729708
>

--00c09fc2bee79283e6048603061b--

Database tables for Exchange rates

I am designing a database to store exchange rates and other information. The
tables fro the exchange rates will store exchange rates fro all currencies.

Can I have any suggestions about the number of tables to use for the
exchange rate? I think I will need at least 2 tables, but I am looking for
suggestions on how to achieve maximum speed when querying the database and
also avoid redundant tables or rows.

Mimi


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Database tables for Exchange rates

--0016e6db2b395e8ba404863ce3fe
Content-Type: text/plain; charset=ISO-8859-1

For the exchange rates only you don't really need more than one table. I
work with an enterprise financial system and we have exchange rate tables
which are updated with data every day.

Something like

BASE_CURR char(3)
NONBASE_CURR char(3)
EFF_DATE DATE
EXCH_RATE DECIMAL(15,6) -- or however much precision you need

We have other columns storing tolerances but that should be enough. First 3
columns are your key.

Separate tables for the currency codes themselves.

On Mon, May 10, 2010 at 7:28 AM, Mimi Cafe wrote:

> I am designing a database to store exchange rates and other information.
> The
> tables fro the exchange rates will store exchange rates fro all currencies.
>
> Can I have any suggestions about the number of tables to use for the
> exchange rate? I think I will need at least 2 tables, but I am looking for
> suggestions on how to achieve maximum speed when querying the database and
> also avoid redundant tables or rows.
>
> Mimi
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=pchapman@nc.rr.com
>
>


--
Distributed Computing stats
http://stats.free-dc.org

--0016e6db2b395e8ba404863ce3fe--

RE: Database tables for Exchange rates

Hi Phil

Yep, it looks like that will do.

Thanks


>> -----Original Message-----
>> From: freedc.bok@gmail.com [mailto:freedc.bok@gmail.com] On Behalf Of
>> Phil
>> Sent: 10 May 2010 13:53
>> To: mysql@lists.mysql.com
>> Subject: Re: Database tables for Exchange rates
>>
>> For the exchange rates only you don't really need more than one table. I
>> work with an enterprise financial system and we have exchange rate tables
>> which are updated with data every day.
>>
>> Something like
>>
>> BASE_CURR char(3)
>> NONBASE_CURR char(3)
>> EFF_DATE DATE
>> EXCH_RATE DECIMAL(15,6) -- or however much precision you need
>>
>> We have other columns storing tolerances but that should be enough. First
>> 3
>> columns are your key.
>>
>> Separate tables for the currency codes themselves.
>>
>> On Mon, May 10, 2010 at 7:28 AM, Mimi Cafe
>> wrote:
>>
>> > I am designing a database to store exchange rates and other
>> information.
>> > The
>> > tables fro the exchange rates will store exchange rates fro all
>> currencies.
>> >
>> > Can I have any suggestions about the number of tables to use for the
>> > exchange rate? I think I will need at least 2 tables, but I am looking
>> for
>> > suggestions on how to achieve maximum speed when querying the database
>> and
>> > also avoid redundant tables or rows.
>> >
>> > Mimi
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=pchapman@nc.rr.com
>> >
>> >
>>
>>
>> --
>> Distributed Computing stats
>> http://stats.free-dc.org


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org