On Mon, 6 May 2002 15:21:54 +0900
Sven Bentlage <[EMAIL PROTECTED]> wrote:
> Hi !
> Just read about the possibility of replicating two databses.
> Can you tell me how to do it or send me a (link to a) manual?
Actually is not only replicating 2 DB, but replication between several DB server.
You c
Hi !
Just read about the possibility of replicating two databses.
Can you tell me how to do it or send me a (link to a) manual?
Thanks,
Sven
On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote:
> On Mon, 6 May 2002 07:44:04 +0200
> "Ewan Sadie" <[EMAIL PROTECTED]> wrote:
>
>> I have i
i got an error msg. that this was not posted... hence i am doing
it once more
Praveen
On Mon, 06 May 2002 p j j wrote :
>hi all,
> I am using mysql on Win98 platoform. Am facing problems
>using the Time field in SQL queries being executed from a VB
>program. Would it be possible for so
On Mon, 6 May 2002 07:44:04 +0200
"Ewan Sadie" <[EMAIL PROTECTED]> wrote:
> I have installed MySQL on two of my MS-Proxy servers. I am logging all
> web browser logs to MySQL.
> I want to replicate the database to a central server where I can do
> queries on the data. I do not want to run select
I am not sure on this one, since I am new to mysql myself.
But how about just entering the appropriate information on the other
host before the database name
i.e. hostname.databasename.tablename
Don't know how or where to privide the user name/pw for tthe 2nd.
server though.
It's just an idea
If you only want to get the Max or min of a single row, then you should try
something like:
SELECT date_value, version_id FROM dates WHERE version_id=2 ORDER BY
date_value DESC LIMIT 1;
However if there might be two of the rows with the highest you will need to
use either a max-concat trick or ta
hi all,
I am using mysql on Win98 platoform. Am facing problems
using the Time field in SQL queries being executed from a VB
program. Would it be possible for someone to help me out with
this
At mysql> prompt
1. CREATE TABLE TEST(field Time) > success
2. INSERT INTO TEST(field)
I have installed MySQL on two of my MS-Proxy servers. I am logging all
web browser logs to MySQL.
I want to replicate the database to a central server where I can do
queries on the data. I do not want to run select statement agains the
proxy server itself.
How can I replicate the data to a differ
Dear all
Two Question :
1.
I know that the 'LOAD DATA' command loads a bulk of data into a table, but
what happen if i only want to load the data into specifc fields on a table
instead of whole table.
eg.
Let say i had a file with 3 column of data, and i want to load these data
into a 'ABC' tabl
Hello,
A real SQL-query works well
SELECT MAX(date_value) AS date_value FROM dates WHERE version_id='2'
But the problem is, that I can't get a value of another column, i.e.
the row in a table consists of three columns - id, date_value and
version_id
The task - to get a value of id column where
Hi,
I got the above error when inserting a row into a heap table on linux
mySQL version 3.23.49a from the Java JDBC driver. This is not reproduceable
on a win32 DB. This does not appear to be space related as it failed after
only about 200 rows. Just wondering if anyone has seen this before?
FilterFodder: sql, query
Yo Jeremy,
On Sunday 05 May 2002 9:31 pm, Jeremy Zawodny wrote:
> That one isn't fixed as easily. ...
> You might be able to use a BETWEEN query:
(eyes raised to heaven, hands clasped in prayer)
o jeremy you are my hero!
(grin)
seriously, thanks a lot, i really apprec
What's going on at Mysql??
When can we expect 3.23.50???
Balteo.
- Original Message -
From: Rodrigo Pérez <[EMAIL PROTECTED]>
To: <>
Sent: Sunday, May 05, 2002 11:32 PM
Subject: Re: Optimization
> Thanks Jay,
> Actually what i want to do is much more simple. I want to have on the sa
Thanks Jay,
Actually what i want to do is much more simple. I want to have on the same
query result, the first 10 rows with this word and the total of rows from
the table with this specific word.
The result should be like a search engine page result. Has the total of
pages with that word and the
On Sun, May 05, 2002 at 04:54:41PM +0100, Donna Robinson wrote:
> Hi Jeremy,
>
> On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
> > REGEXP queries don't use indexes. Change the:
> > REGEXP "^A"
> > to
> > LIKE "A%"
> > and it'll use the index and give you a nice speed boost.
>
> which
I am trying to install mysql on my home computer. I teach Web Design at
DeVry University and plan to use this database in my class. The error
message I get is Setup Initialisation Error "Setup is unable to find
installation languages in C:\mysql\setup.lid file" and "Error 105." My next
clas
On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote:
>
>
> >Is /tmp/mysql.sock missing after you start the MySQL server using
> >`bin/safe_mysqld'?
>
> When I run bin/safe_mysqld I get the message that it is unable to
> connect to 'hostname' through /tmp/mysql.sock and that it is missing
>Is /tmp/mysql.sock missing after you start the MySQL server using
>`bin/safe_mysqld'?
When I run bin/safe_mysqld I get the message that it is unable
to connect to 'hostname' through /tmp/mysql.sock and that it is missing
Cheers
---
Hi Jeremy,
On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
> REGEXP queries don't use indexes. Change the:
> REGEXP "^A"
> to
> LIKE "A%"
> and it'll use the index and give you a nice speed boost.
which indeed it did! I checked the manual (yet again) and it doesn't actually
say anythin
Why do you want to restrict the names to be unique?
//Anders - SQL, QUERY
-Original Message-
From: Shaun Bramley
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 3-5-02 20:16
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for your qu
IMO the desire to know this answer suggests that something is wrong with the
design. Again IMO, a PK must be absolutely meaningless. Any attempt to
impost meaning on it is by definition wrong.
By my lights, the only PK you want to know is the one just added. That's
enough information to let you s
Hello,
Are there any plans for releasing AIX 5L pre-compiled binaries? I notice there
are some MySQL RPMs available from other locations but they are not the latest
version.
If not, are there any pointers to AIX 5L compilation steps?
Viraj.
-
When I run setup.exe I get a Setup Initialsation Error "Setup is unable to
find installation languages in C:\mysql\SETUP.LID file" and "Error 105."
Please tell me what I am doing wrong so I can get MYSQL running.
Ray Bell
-
B
If You're using VC++ so I recommend You to test run
Your app within VC++ IDE.
Then You can step through your code , line by line and
check for variables if they are what You think they are.
A very easy and effective way to find errors !!
---
=d0Mi= , DCS
Hello .
I'm a small VC++ programmer , and I have some problems with mysql c
functions.
What I wanna do , and I don't know how, it's to get an field value from a
table and put it in a char* or into an int
For instance , I have a small table , with two fileds
name char(50),
age int(40)
25 matches
Mail list logo
