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 u
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 INTO
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 i
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
`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 pas
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
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
offi
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 t
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 10:26
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 Message
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 [mail
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
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
-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 B
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 cluste
15 matches
Mail list logo
