int
date datetime
Essentially, the client enters his id and it creates a record in the
signin table.
I need a query that can identify all the clients who signed in for the
first time during a specific month. I have fought this one for a
couple of days now and just can't seem to get it.
--
Aaron
I am trying to write a script that can take logs from our mail server, boil down the
rejections to determine the sources of distributed SMTP dictionary attacks against our
mail server.
Basically I have a table send_failures like this that gets fed with the raw data from
the logs:
host_ip
I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to
write queries dealing with IP addresses. Specifically, I have a table with an ip
address field. I want to be able to do queries based on subnet. Has anybody got
anyting like this?
--
Aaron Clausen
[EMAIL
database and pipe it into a test database. I found
mysqldump to have a bit of a learning curve, but I could not survive without
it now.
--
Aaron Clausen
-
Before posting, please check:
http://www.mysql.com/manual.php
. Even better, mysqlbackup generates SQL files, which, with a
little manipulation, can be imported into other database systems.
--
Aaron Clausen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
in the next six months. But MySQL has been rock solid.
I have lost no data, save through my own stupidity, at any point. I would
recommend it without reservations.
--
Aaron Clausen
-
Before posting, please check:
http
.
In other words, the rule of thumb should be Keep it simple, stupid.
--
Aaron Clausen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I've been having some problems with currency calculations in SQL queries.
I've been using Double, but often get some very small rounding errors. What
is the recommended column type for currency in MySQL?
Aaron
-
Before
How much difficulty is there in turning a MySQL replication server into a master?