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 des
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 contains
Sent: Tuesday, 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:
> >
> >
> &
> -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 0
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
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: Oka
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
master-host=x.
From: 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
Did you ever get any confirmation that it will be added to the official
bug list?
-Original Message-
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 3:14 AM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Replication bug?
Yes this is
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
||...
11 matches
Mail list logo
