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
Simply said this works:
drop table if exists detail;
create table detail
(
detail_id int not null auto_increment
, master_id int not null
, name varchar(50) not null
, primary key (detail_id)
, index master_idx(master_id)
, foreign key (master_id) references master (master_id) on delete
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
||
When I try to change the id field in the parent table below, I get the
error: 1217 - Cannot delete a parent row; a foreign key constraint fails.
What have I got wrong? Shouldn't it cascade the changes that were made to
the parent down to the child table?
This is done with Mysql 3.23.50-max
It would seem strange to implement one and not the other? The help does say
that you can use it and does keep the create options now.
Does anyone know if this will be implemented in the next .5x release?
Ross
Me writes:
Hi!
don't think ON UPDATE is supported.
The manual :
On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
stable.
However on the download page it is said to be considered a beta yet?
The reason that I am asking this question, is that the Borland Delphi
Developers will not release a new version that supports the record
14 matches
Mail list logo