... WHERE noticed='scan'"
...
and finally it should "UPDATE domain=whatever, ... noticed='done'"
Thanks Don.
That means, when process one want to update "ip" but it see
noticed="scan", it will block until the status become "done", is it?
E
two has gotten the outdated IPs (not the
new ones updated by process one), since it will set noticed=1 finally so it
doesn't have a chance to find it's using old IPs.
So how to resolve this problem?
Thanks for my newbie questions.
Merry Holidays!
Eva.
#x27;t know how to control the IP's attributes if I set this
table-stru.
Please help,thanks.
Eva.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello Listers.
I would like to upgrade from 3.4 to MySQL 4.1 and would just like to know.
Any Apps that have been compiled using ./configure --with-mysql option.
Would these apps have to be recompiled?
Regards
Denham Eva
ORACLE DBA.
<-- Your information went that way -->
--
MySQL G
this should work:
select NAME, sum(if(IF_PURCHASED='true',COUNT,0)),
sum(if(IF_PURCHASED='false', COUNT,0)) from TABLENAME group by NAME;
eva
-Original Message-
From: cengiz "taţhan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 9:29 AM
To: [EMAIL PRO
peopleID should match:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I made a small DB of people and mach
try:
select limit , 1
eva
-Original Message-
From: Marc Bakker [mailto:[EMAIL PROTECTED]
Sent: 29. marca 2003 16:55
To: [EMAIL PROTECTED]
Subject: MySQL: Selecting a patricular row
Hello,
I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5
rows. I want to
i would use following
$query_del = "UPDATE favorites set
favorites='".REPLACE(favorites,'BitOfStringToReplace','NewBitOfString')."'
WHERE
email='$email' AND password = '$pw'";
eva
-Original Message-
From: Dillon
select headline, count(*) from headlines_table group by headline;
Eva Parackova
[EMAIL PROTECTED]
-Original Message-
From: Michelle de Beer [mailto:[EMAIL PROTECTED]]
Sent: 3. decembra 2002 13:27
To: mysql list
Subject: Select and count duplicates
I have a column containing headlines
Hi all.
I would like to know why i cannot install the DBD-MySQL-2.1009 on my
computer. I use Perl 5 (ActivePerl build 630) and i have already install
some modules like DBI1.20 and some others (CSV, etc...) and it's always
very easy (using Perl MakeFile.PL - nMake - ) and work perfectly well.
D order by ... , ... limit 0,20;
Eva Fransson
- Original Message -
>
>
> Does it throw an error message or output isn't what you expected?
> In any event, did you try it with "HAVING"?
>
> I couldn't notice anything wrong from what you have there
>
>
If you want to use your table more than once you have to declare that.
select ... from T1 as FirstT1, T2 as SecondT1 where
FirstT1.column...=SecondT1.column...;
Eva Fransson
-
Before posting, please check:
http
re ... and ... group by fkEmployeeID order by ... , ... limit 0,20;
But it dosn't! Is there some other way to fix this?
Eva Fransson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Jermey,
I would really appreciate that. Our sysadmin said it'll take another few
days before I can get the latest gnu compiler.
Thanks,
-eva-
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 3:47 PM
To: Eva Hammel
Cc: '[EMAIL
iles. But out gnu
compiler is an older version. And there is a lot of hoops to jump to get
the latest version.
Thank-you for all your work!!
-eva-
THIS TRANSMISSION, INCLUDING ANY ATTACHMENTS OR FILES,
CONTAINS AIRNET COMMUNICATIONS CORPORATION CONFIDENTIAL
AND PROPRIETARY INFORMATION WH
15 matches
Mail list logo
