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
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
On 2010-05-09 13:29, Prabhat Kumar wrote:
INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
NOW()');*
Last_SQL_Error: Error 'You have an error in your SQL syntax; check the
manual that corresponds to
Thanks, It worked :)
On Mon, May 10, 2010 at 6:25 PM, Jay Ess li...@netrogenic.com wrote:
On 2010-05-09 13:29, Prabhat Kumar wrote:
INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
NOW()');*
Hi Phil
Yep, it looks like that will do.
Thanks
-Original Message-
From: freedc@gmail.com [mailto:freedc@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
Hi,
I am exploring multiple instances with MySQL which will be running using the
same set of binaries (single MySQL base). Two things which I'm not able to work
out are -
1. Why mysqld_multi stop grp_id doesn't work? Well, I know why it
doesn't because there is nothing in the script