delete from TABLENAME where CONDITION
- Original Message -
From: "M.D. DeWar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 3:50 PM
Subject: db maint
: Hello
: WARNING::Newbie.
:
: I have snort running and putting alerts into a mysql database.
: I see that
what type is item_id?
That query is looking for a value in the field item_is that is equal to the
a constant string "itemId". is there a record with the value in it?
- Original Message -
From: "florentina kore" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 13,
You need to do a count before your select, use limmit to only select a set
number of records. That way you can work out how many pages there are and
just have a link. You run the same query for each page except that the start
record for the "limit" is the pagenumber * number of records per page.
-
Ye, me to, only its solaris 9. Dosn't matter what server you have
though.
phpMyAdmin is cool, I use it most of the time. Runs on the apache server
(also solaris), works like a dream in every browser I have used so its
fairly platform independant. :-)
- Original Message -
From: <[
You can get Native database drivers for Delphi to talk to MySQL your
database back end makes no differance to any thing with Delphi
God know what perl has to do with any thing totaly not the same thing as
Delphi
Soap supports every thing, soap is language independant... and is fai
Would that be are there mySQL drivers for use on packet pcs with VB?
- Original Message -
From: scr informatiques
To: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:57 PM
Subject: connexion avec un pocket pc
bonjour,
nous souhaitons que des utilisateurs m
I'd hardly call it a war, more of a skirmish, if that. perhaps at best
it should be considered a Terrorist action, don't think it even gets up to
an "Act of Terror" which is good, because I don't want the American Jack
Boot of Opression on my back, thank you very much.
- Original Mess
Access is not a Database, its a kiddies toy.
You can just as easlily make your reports using crystal reports or any thing
else like that if you really want to, or PHP/ASP
Now, please, for suggesting there is any use what so ever in the world for
access, please take your self out back and
Don't forget that if you "commit" then last_insert_id will return 0
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 6:56 PM
Subject: Re: last_insert_id()
: R.Dobson said:
: > Hi,
: >
: > Is it possible to o
paradox for dos or paradox for windows?
If you can write object pal then you can easily write an export to text
I love Paradox, use to be an PAL developer when I was little. and an
Object PAL contractor later, ah, the good old days :-)
- Original Message -
From: <[EMAIL PROTECTED]>
That was an amazingly vage question. But first thoughts would be yes and no.
You can do grouping, but you can't really do it conditionaly with out code.
SQL dosn't support much in the way of logic. So, basicly you do the
"conditional" part in code, then the grouping with SQL. If you want the data
g
That query will work. The note is just dosn't matter, when building your SQL
statment replace it with a varible. In PHP for instance you can do the
following
$IDValue = 100 ;
$Query = "SELECT id FROM myTable WHERE infoId IN (3) AND id $IDValue ORDER
BY id ASC LIMIT 49,1" ;
Job done. No idea why
I have only one thing to say really on this. Data never has any meaning at
all. It is simply data, and not information. Information is extracted from
data and is then given meaning by the viewer of the data.
In the case of NULL I have always thought of it is simply "undefined". Thats
what Orecal s
try ISO standard dates MMDD
- Original Message -
From: "Lakshmi Chennareddi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 4:17 PM
Subject: Reading Date from a csv file
: I am new to mySQL.
:
: I am trying to import data from a csv file, using the fol
PM
Subject: Re: select data from two tables without join
: I'm using 3.23.56, so UNION is out. MERGE looks like it might do the
: trick. The tables are duplicate other than the field names. The
: structure is identical.
:
: On Tuesday, September 16, 2003, at 08:32 AM, Haydies wrote:
:
: &g
t that. It works really well with PHP. This is also a
solution if you are using MySQL 3.x as that dosn't support UNION.
Haydies.
- Original Message -
From: "Tony Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 2:01 PM
Subject
Ye, NULL = "Undefined" in every database I've ever used.
Null and "" are not equal, NULL and NULL are not equal eigther. Infact
absolutly nothing is ever equal to NULL.
Haydies.
Database/PHP Developer
- Original Message -
From: "Paul DuBois" <
Its a compound key, they are always slow. I would imagin you will need to
seriously redesign your database to speed that up. I'm not 100% sure how the
index is stored, but it would be some what pointless if it was individual
field values. Its like haveing "field1field2feild3field4field5" so that a
18 matches
Mail list logo