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.
--
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
[
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
the database
server over to Linux 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
-
ng
mysqlbackup. Works fine and I have used it for restorals on a number of
occasions. Even better, mysqlbackup generates SQL files, which, with a
little manipulation, can be imported into other database systems.
--
Aaron Clausen
--
counting system, and to test out bug fixes, new features, etc., I'll just
dump the running 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
--
other marketing-driven fad.
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://lis
How much difficulty is there in turning a MySQL replication server into a master?
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 postin
