believe using bind variables whenever possible also helps
prevent this attack.
-Jason Martin
--
S met ing's hap ening t my k ybo rd . .
This message is PGP/MIME signed.
pgpBcno4Qf3S7.pgp
Description: PGP signature
woudn't want one index that contains all fields, as there is
no efficient way to search it for a field that isn't on the
'leading edge' of the index. You'd be better off with a seperate
index for each field.
-Jason Martin
--
If you don't like the news, go out and make some of your own.
This message
I'd really suggest looking at the data model that requies you to
dynamically select which table to read from, and find another
way. If there are several tables that have the same column that
differ only by name, why not make the name a column?
-Jason Martin
On Sat, Nov 19, 2005 at 02:28:41PM
On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote:
Snort v2.4.3
ACID v0.9.6b23
I seem to recall hearing that ACID is deprecated; you might want
to look around if there is a newer equivalent. SQUIL
(http://sguil.sourceforge.net/) is supposed to be really good.
-Jason Martin
--
I have
future. Maybe you'd better choose a field type that can
accomodate those as well as the traditional 123.123.123.123 type
I believe both 14v6 and ipv4 can be expressed as decimal numbers
too.
-Jason Martin
--
This Charlie Brown must have been a very wise man.
This message is PGP/MIME signed
On Tue, Nov 01, 2005 at 02:38:29PM -0800, Kevin Burton wrote:
Gangla and Cacti seem to do similar tasks (if you stretch them) but
they really fall down fast.
Can you elaborate on 'fall down fast'? It should be a really
simple operation to do this in cacti.
-Jason Martin
--
SYSTEM ERROR
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The oracle-supplied DBMS_METADATA package can do this for you.
-Jason Martin
--
Silence
not have to overlap.
-Jason Martin
--
Reduce Carbon Dioxide emmissions - STOP Breathing
This message is PGP/MIME signed.
pgpoEeMSujkX4.pgp
Description: PGP signature
the
transaction in Window B. See the manual for details
http://dev.mysql.com/doc/mysql/en/innodb-consistent-read.html
Is this a known bug?
It's not a bug.
Oracle works in a similar fashion.
-Jason Martin
--
Never eat anything bigger than your head.
This message is PGP/MIME signed.
pgpnWgmFXjYfU.pgp
multiple schemas.
-Jason Martin
--
I'd love to, but I have to rotate my crops.
This message is PGP/MIME signed.
pgpjwHryLEUmW.pgp
Description: PGP signature
On Fri, May 20, 2005 at 09:28:40AM -, [EMAIL PROTECTED] wrote:
Hint: Did you specify a password for the login ?
I suspect the original poster was saying that he doesn't
remember setting a password, so he doesn't know what password to
enter.
-Jason Martin
--
Unrecoverable Application ERROR
.
Such a thing isn't possible as it would require MySQL to update
every row 'past' the deleted row. Why do you need to do this?
-Jason Martin
--
Oxymoron: Steel wool.
This message is PGP/MIME signed.
pgpdul81Q104Q.pgp
Description: PGP signature
with
SELECT `id` FROM `thetable` WHERE `type` LIKE '%category3%';
That query will not be able to use indexes and will be too slow
to use in any sizable database.
-Jason Martin
--
Nobody home but the lights, and they're out too.
This message is PGP/MIME signed.
pgpJnyYA6U07B.pgp
Description
On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote:
There should be tools on this website, but i see only a message from
Infektion Group.
What happened ?
Looks like the website got hacked.
-Jason Martin
--
Useless Invention: Motorcycle seat-belts.
This message is PGP/MIME signed
that is usually the result of a
hardware problem. In 'top' is the process stuck on 'D', ie
waiting for a disk to respond?
-Jason Martin
--
If you can't debug it, deplug it.
This message is PGP/MIME signed.
pgp660FTDZ8an.pgp
Description: PGP signature
On Mon, Jan 31, 2005 at 06:57:58PM +, Edward Macnaghten wrote:
1 - The output is not cluttered with headers, and a means exist to
easily separate fields when there is more than one column or row in the
query.
The mysql --batch option should take care of that for you.
-Jason Martin
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote:
but I'm having the most frustrating problem. Data I've inserted simply
VANISHES.
What is the setting for AutoCommit? If it is 0, are you sure
that commit is being called before the session ends?
-Jason Martin
inserting the data:
mysql_query(COMMIT, $this-dbh);
and see if that changes anything.
-Jason Martin
--
My karma ran over my dogma
This message is PGP/MIME signed.
pgpplCPHXl079.pgp
Description: PGP signature
On Wed, Jan 26, 2005 at 01:56:05PM +, Pupeno wrote:
Takes more room because of the extra field ? Can you tell me more about 'the
normalized approach' ?
http://en.wikipedia.org/wiki/Database_normalization
-Jason Martin
--
If you cannot convince them, confuse them.
This message is PGP/MIME
On Fri, Jan 21, 2005 at 09:21:18AM -0500, Eben Goodman wrote:
connection layer, and based on time of day or something passes a
You could use a TCP load balancer such as Balance or PEN, or you
could modify the code to randomly select a server name from a
list at connection time.
-Jason Martin
a table that way. However when selecting the
data you can do
select (field2+field3) FIELD1, field2, field3 from table
such that you'll get the calculated field.
-Jason Martin
--
When I tried to take an ego trip I got stopped at the border
This message is PGP/MIME signed.
pgpwOoiS87sEx.pgp
On Tue, Jan 11, 2005 at 11:44:34AM +1100, Daniel Kasak wrote:
Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
JPGraph
On Tue, Jan 11, 2005 at 05:55:31PM +0100, Olivier Kaloudoff wrote:
Cacti, based on mysql stored rrd database is probably the kind
of tool you are looking for;
Ahh, so is there a cacti-like tool that understands MySQL?
Thanks,
-Jason Martin
--
This message is PGP/MIME signed
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
Thanks,
-Jason Martin
--
You can't go home again, unless you set $HOME.
This message is PGP/MIME
once known it can be
used in another script. You should concentrate on protecting
that file.
-Jason Martin
--
Any philosophy that can be put in a nutshell belongs there
This message is PGP/MIME signed.
pgpvmpfpEhT4g.pgp
Description: PGP signature
25 matches
Mail list logo