Hello Baron, thanks for your response.
> These types of questions can always be answered by asking: "does my
> proposed setup require any server to have more than one master?" If
> so, it's currently not possible.
What I want to do is the following:
eGroupware is a enterprise-groupware solution.
---
From: Frank Becker [mailto:computersac...@beckerwelt.de]
Sent: Tuesday, January 13, 2009 12:33 PM
To: mysql@lists.mysql.com
Subject: Question about Master-Master replication: Is this possible?
Hello together,
I have successfully set up a master-master-replication between two
servers. My que
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
wrote:
> Hello together,
>
> I have successfully set up a master-master-replication between two
> servers. My question is: It is possible to set up such a replication
> between three (or more) servers? Like this
>
>
> Master3 --- Master1 --- Master2
>
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 --- Master1 --- Master2
|
Master4
Thanks for your feedback
Best r
On Wed, 2004-03-31 at 16:08, Chris Boget wrote:
> I have 2 tables (looks best in fixed width font):
>
> test_items
> +---+--+
> | name | rec_num |
> +---+--+
> | Book | 1|
> | Game | 2|
> +---+--+
>
> test_attributes
> +---+-
> GROUP_CONCAT() is in 4.1. :-)
Oh, so close yet so far. We're running 4.0.14 and my company has
no plans on upgrading in the near future. *sigh*
Thanks for the info, however!!
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
Hi,
GROUP_CONCAT() is in 4.1. :-)
Matt
- Original Message -
From: "m.pheasant"
Sent: Wednesday, March 31, 2004 5:26 PM
Subject: RE: Is this possible?
> You would need an aggregate concat() function I think its in 5.0
> m
>
> -Original Message-
>
You would need an aggregate concat() function I think its in 5.0
m
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 7:08 AM
To: MySQL
Subject: Is this possible?
I have 2 tables (looks best in fixed width font):
test_items
I have 2 tables (looks best in fixed width font):
test_items
+---+--+
| name | rec_num |
+---+--+
| Book | 1|
| Game | 2|
+---+--+
test_attributes
+---++
| item_rec_num | attribute |
+---++
|
thanx for reply but not a good idea. Though i did it through PHP script
Nitin
- Original Message -
From: "Mechain Marc" <[EMAIL PROTECTED]>
To: "Nitin Mehta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 16, 2004 1:38 PM
Subject:
ED]
Envoyé : vendredi 16 janvier 2004 06:28
À : [EMAIL PROTECTED]
Objet : is this possible?
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx i
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
S B)
AND NOT EXISTS
(
SELECT *
FROM load_cntl AS B
WHERE B.LOAD_DATE = DATEADD(A.LOAD_DATE, 1)
)
Good Luck!
Charlie [EMAIL PROTECTED]/Shield/Michigan
> From: Mark Marshall Date: December 10 2003 6:01pm
> Subject: SQL Statement Help - Is this possible?
>
> I have
I have a database table that has one row entered every day by the user.
If the user skips a day, it throws off our monthly totals. Assume a
table with four columns:
id (which is the key), date (-mm-dd), data1 (int), data2 (int)
Is there a way to say "Select the first missing date in the
Am looking for a way to have our website database updated automatically
during the night.
We hv a little prog that takes data from a sybase database and creates a
sql/txt file.
Am hoping there's a way to have this file send to the website (ftp?) and
than automatically run on the website to enter t
| 166| v007-86.jpg | demonstrations, people|
| 167| v008-03.jpg | demonstrations, people|
+---+---+--+
Where the categories have been collected together into the same field,
so that I don't get multiple rows for the same file… Is this possible
to achieve?
Hello folks
(BIs it possible to install a MySQL server into the /home/*username*
(Bdirectory in a typical Linux Installation. If so
(B1. where to put those my.cnf files and set the global options for a
(Bparticular user.
(B2. How to connect to that database from a remote machine, knowing t
On Fri 2003-01-24 at 07:59:16 -0600, [EMAIL PROTECTED] wrote:
> sub-selects are not yet (to the best of my knowledge) supported in MySQL.
To be a bit more precise: They are not supported in any stable release
of MySQL. They are going to be supported in Version 4.1, which is
still declared alpha. M
gt;
Sent: Thursday, January 23, 2003 6:24 PM
Subject: Re: Is this possible?
> I believe a sub-select with the DISTINCT command would do it.
> You would have to look up the syntax.
>
> Also, it seems that some people seem to be having a problem with
> sub-selects but
> I don
UALCOMM Windows Eudora Version 5.1
Date: Thu, 23 Jan 2003 16:24:11 -0800
To: "Doug Coning" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
From: Frank Peavy <[EMAIL PROTECTED]>
Subject: Re: Is this possible?
In-Reply-To: <023f01c2c313$5a2feb40$0a01a8c0@GIDEON>
References:
I believe a sub-select with the DISTINCT command would do it.
You would have to look up the syntax.
Also, it seems that some people seem to be having a problem with
sub-selects but
I don't have any direct experience to convey.
At 01:12 PM 1/23/03 -0600, Doug Coning wrote:
Is this possib
oning" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 1:12 PM
Subject: Is this possible?
> Is this possible in MySQL without using a temporary table with multiple
SQL
> commands:
>
> I am trying to SELECT the results of multiple columns
Is this possible in MySQL without using a temporary table with multiple SQL
commands:
I am trying to SELECT the results of multiple columns into 1 column or
Alias,
group them and sort them.
So if I had a table with 4 fields: Cat1, Cat2, Cat3, & Cat4 like such:
+-+--+-+--+
|
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Doug Coning" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 9:15 AM
Subject: Re: Is this possible?
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filt
I would like to know if this is at all possible using MySQL 4.0.4 in
Windows.
We want to be able to host our web site using either Windows and ASP or
Linux and PHP in our service provider server. All the scripts will be in
their machine away from our network. Then I would like for those scripts
hp-General
Subject: [PHP] phpMyAdmin is this possible
I am new to MySQL and PHP.
Having looked at PHPMyAdmin the GUI I was wondering if it's possible to
create a new database within the system?
If so what are the commands? I ask because I only have one database on my
server and don't want
I am new to MySQL and PHP.
Having looked at PHPMyAdmin the GUI I was wondering if it's possible to
create a new database within the system?
If so what are the commands? I ask because I only have one database on my
server and don't want to populate it with different tables, I'd rather have
seperate
Steen
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Steen Rabol'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 9:35 PM
Subject: RE: Is this possible in one SQL statement
> Please restate the foll
quot;Rick Emery" <[EMAIL PROTECTED]>
To: "'Steen Rabol'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 9:35 PM
Subject: RE: Is this possible in one SQL statement
> Please restate the following more completely. I think some ty
related to fields.
Original Message:
-
From: Steen Rabol [EMAIL PROTECTED]
Date: Thu, 31 Jan 2002 21:24:43 +0100
To: [EMAIL PROTECTED]
Subject: Is this possible in one SQL statement
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
table
with the value of 3
-Original Message-
From: Steen Rabol [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:25 PM
To: [EMAIL PROTECTED]
Subject: Is this possible in one SQL statement
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
Is this possible in a single select statement ?
table A id (Unique), a_field1,a_field2,a_field3
table B id(NOT unique), b_field1
Id in table B is a ref to id in table A
Now i would like to select all the id's from table A which have records i
table B where b_field1 is 1 and b_fiel
* Stig Nørgaard Jepsen
> > Do you need to read _all_ textkeys for each page? How many different
> > textkeys do you have in the table?
>
> No I don't have to read all the textkeys at once. They are
> usually selected via a join from another table. And sometimes I
> will read a set of rows via a se
> > I would emagine that only one 'left join' takes less processing power?
>
> Yes, but I don't think there is very much extra processing time involved
> using one more join in most cases, as long as the join is indexed and the
> index blocks involved are cached, or if the amount of data is reaso
* Stig Nørgaard Jepsen
> > select distinct
> > t1.textkey,
> > if(t2.textid,t2.languageid,t3.languageid) as languageid,
> > if(t2.textid,t2.textid,t3.textid) as textid,
> > if(t2.textid,t2.textvalue,t3.textvalue) as textvalue
> > from texts t1
> > left join texts t2 on
> > t2.textkey=t1.
> > Ok, I will, but I CC it to the mailinglist, maybe others have interest
> > and/or comments. Besides, I think I may have found a bug...
>
> Yes, of course my fault not to post directly to the list :)
>
> I have another problem with this query.
> If the textvalue field is the text type, then i
> select distinct
> t1.textkey,
> if(t2.textid,t2.languageid,t3.languageid) as languageid,
> if(t2.textid,t2.textid,t3.textid) as textid,
> if(t2.textid,t2.textvalue,t3.textvalue) as textvalue
> from texts t1
> left join texts t2 on
> t2.textkey=t1.textkey and
> t2.languageid='da'
> le
> Ok, I will, but I CC it to the mailinglist, maybe others have interest
> and/or comments. Besides, I think I may have found a bug...
Yes, of course my fault not to post directly to the list :)
I have another problem with this query.
If the textvalue field is the text type, then i get this erro
* Stig Nørgaard Jepsen
> It's a miracle! Thank you so much. I didn't think it was possible.
> It seems to work alright.
:)
The LEFT JOIN and IF() combination is quite powerfull.
> But i really don't understand what happens.
> I would be very glad if you could explain for me what's the
> princip
Stig Nørgaard Jepsen wrote:
> > You may try this and see if it works (didn't test it, just jotted it down
> > here):
> >
> > select t1.textid, t1.textid, t1.textvalue
> I just don't understand why you did this?
> Why select t1.textid twice?
Ugh... That was a mistake -- I actually meant t1.textid
* Stig Nørgaard Jepsen
> Is it possible to make a query in MySQL, which could return row
> 1,3 and 4 based on these conditions?
select distinct
t1.textkey,
if(t2.textid,t2.languageid,t3.languageid) as languageid,
if(t2.textid,t2.textid,t3.textid) as textid,
if(t2.textid,t2.textvalue,t3.te
> You may try this and see if it works (didn't test it, just jotted it down
> here):
>
> select t1.textid, t1.textid, t1.textvalue
I just don't understand why you did this?
Why select t1.textid twice?
> from texts as t1, texts as t2
Again I don't understand this...
Wouldn't t1 and t2 be the s
You may try this and see if it works (didn't test it, just jotted it down
here):
select t1.textid, t1.textid, t1.textvalue
from texts as t1, texts as t2
where
(t1.languageid='$Primlanguage' and t1.textid=t2.textid) or
(t1.textid=t2.textid and t2.languageid='$Seclanguage' and
t2.lan
I have this table:
CREATE TABLE texts (
textid mediumint(9) NOT NULL auto_increment,
languageid char(2) NOT NULL default 'da',
textkey varchar(32) NOT NULL default '',
textvalue text NOT NULL,
PRIMARY KEY (textid),
)
It could contain these data:
(textid,languageid,textkey,textvalue)
1
At 4:51 PM -0700 10/31/01, Nathan wrote:
>I have a table(2) with a different structure than the table(1) I'm
>selecting from. I want to be able
>to grab some info from table1, put it in table2, along with some
>variables from my php page. Is it
>possible to do like:
>
>INSERT INTO table2 VALUES
I have a table(2) with a different structure than the table(1) I'm selecting from. I
want to be able
to grab some info from table1, put it in table2, along with some variables from my php
page. Is it
possible to do like:
INSERT INTO table2 VALUES 1,2,3 SELECT 4,5,6 FROM table1
Or do I need to
hey guys
I need something similar:
first and foremost, i need all the info about evry customeri have, and then
a count of how may order then have for me. (never got it working)
im guessing something like this
select *,count(*) as orders from C,O group by O.domain having orders>-1
however, this
>
> Incredibly difficult.
>
> select foo,count(*) as cnt from da_table group by foo having cnt >1;
>
ahh, I'd be slapping my forehead right now, except I've never used "having"
Thanks for helping out. :)
Stephen
-
Before po
On 15-Aug-2001 Stephen VanDyke wrote:
> Ok here's the current method I'm using to find non-distinct records in a
> table:
>
> 1) SELECT DISTINCT column1 FROM table WHERE column2='something'
>
> 2) I get an array and mash it together [PHP: $biglist =
> "'".implode("','",$column)."'";]
>
> 3) SE
Ok here's the current method I'm using to find non-distinct records in a
table:
1) SELECT DISTINCT column1 FROM table WHERE column2='something'
2) I get an array and mash it together [PHP: $biglist =
"'".implode("','",$column)."'";]
3) SELECT column1 FROM table WHERE column1 NOT IN($biglist);
mysqldump creates a text file with such structure.
- Original Message -
From: Joel Holtzman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:47 AM
Subject: Is this possible
> Hello, I am starting to get some success from Load data. Ok
Hello, I am starting to get some success from Load data. Ok, now with that,
here's my question, 'cause I can't find the answer in the manual.
Can I create a table *solely* by pointing to a text file with the
coloumns/records as part of the text file?
What I mean is, instead of creating the colum
52 matches
Mail list logo