I want know if there is a way to return every date between 2 date ranges
regardless if there is a row in a table. I have a table that contains
daily pricing information and I want to be able to do a mass
updated/insert records. I know how to write the updates/inserts if I
have table that
That will only return the number of rows in Table1 What I want to
return 1 to n rows based on the number of days between date1 and daten
with each row having the date filled in.
Ross Davis
DataAnywhere.net
250-470-9192
ChaletsOnline.com is coming soon
Don't you deserve a vacation
I agree with you. If there is no index already on the referenced fields
then add one. By adding a foreign key you are already altering the
table why not just finish the job.
-Original Message-
From: Natale Babbo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:58 AM
To:
I have a 3.23.53 server that is a slave of another 3.25.52 server.
Master has 2 databases on it.
On the slave only only one of the databases is replicated.
If I reference the table database that is not on the slave during an
insert or something on the server it crashes the slave!
Shouldn't the
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 4:00 PM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Design feature or bug
On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis -
DataAnywhere.net
, January 14, 2003 6:18 PM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Design feature or bug
On Tue, Jan 14, 2003 at 04:41:53PM -0800, Ross Davis -
DataAnywhere.net wrote:
I stand corrected. In a production environment a stopped
server
I don't think I have anything that should cause this. Here is my my.ini
from the the slave. The tables that are being excluded are not listed.
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
set-variable=max_allowed_packet=16M
log-slave-updates
log-bin
# Replication variables
: Frederick R. Doncillo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 10:58 PM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Replication bug?
Are the slaves doing the replication process? If not, you may try it
that way. Slaves should do the updating and must
I think I have found a replication bug. We are using Mysql-Max 3.23.53
in a master and multiple slave situation. That is working fine. We are
using InnoDB
We have found a workaround to the problem but I thought you should know
about it.
We have 2 databases on the system call them dba and dbb.
I am about to setup the following server layout using all Windows 2000
Server and XP Pro machines.
Master Server-|
|--Branch Office Server -|
||- Machine 1
||
10 matches
Mail list logo