Hi,
I would be setting up a mysql cluster, i'm researching what's the
minimum number of machine to make sure i have fault tolerant and data
backups. I found this:
Q: What are the minimum system requirements for MySQL Cluster?
A: A minimum of three computers is required to run a viable
-What I'am trying to do:
Bit hard to explain. I've got a table consisting of ip addresses
(ipv4_src), destination addresses (ipv4_dst), and port numbers
(port_dst) and some other irrelevant columns. Ultimately my goal is to
find a linear order in a subset of ports. For example, host A connects
to
I have googled, read the mysql documentation and searched the list archive.
I don't know if I just don't know the correct term to use or if I have some
other problem.
In a nutshell I generate packing lists where the items are normally sorted
alphabetically. However, there is one type of item that
David Ruggles schrieb:
I have googled, read the mysql documentation and searched the list archive.
I don't know if I just don't know the correct term to use or if I have some
other problem.
In a nutshell I generate packing lists where the items are normally sorted
alphabetically. However, there
Try One of These:
SELECT name,species,birth FROM animalsORDER BY
IF(species='hamster',0,1),species;
OR
SELECT name,species,birth FROM
(SELECT name,species,birth,IF(species='hamster',0,1) sortorder
FROM animals) A ORDER BY sortorder,species;
-Original Message-
From: David Ruggles
Try One of These (including name):
SELECT name,species,birth FROM animals ORDER BY
IF(species='hamster',0,1),species,name;
OR
SELECT name,species,birth FROM
(SELECT name,species,birth,IF(species='hamster',0,1) sortorder
FROM animals) A ORDER BY sortorder,species,name;
-Original
Thank you very much, that seems very simple now that I see it.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008
Hi,
Have you tried changing the date format like
delete from TelecomAccountPosting where LocID=19014 and InvDate='2008-01-15';
I know it shouldn't matter but I have had similar issues due to the date
format.
Also are you sure there are 3773 records matching this criteria - according to
your
Hi,
We normally use the binaries, but there's a few patches I want to try
out, so I've gotten the source. Now I've also compiled sources many
times, so that process isn't a problem. However, what I wanted to do is
try to compile the source with the exact same configure options that the
Hello,
I was pulling data from one datasource [ oracle ] earlier which had a couple
of fields as integer. Now i am moving to a newer data source and the same
fields are now varchar's in the newer oracle database.
I am planning to change the data types of those fields from integer to
varchar's as
`method` is the name of the column in the table.
In my opinion it should return every record from the table where `method` is
equal to NULL, ZERO or EMPTY STRING, as this table doesn't allow null, and
the field type is varchar, this would be EMPTY STRING's only.
This has always worked in the
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop index
5) execute same
mysql mysql wrote:
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop
Hello,
Doing C coding with MSql.
What am I missing here?
I am needing to do standard INSERT statements using variables for the VALUE
fields
These fields are changed in the application befre I issue the INSERT. The
current proram uses : before the variable to make it work.
Like this: INSERT
In the last episode (Jan 22), [EMAIL PROTECTED] said:
Hello,
Doing C coding with MSql.
What am I missing here?
I am needing to do standard INSERT statements using variables for the
VALUE fields These fields are changed in the application befre I
issue the INSERT. The current proram uses :
15 matches
Mail list logo