Syntactic Confectionery Delight | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
This somewhat looks familiar. Kind of like what's on page 364 of "Writing Apache Modules with Perl and C" - A DBI Database Logger. Must be the table.
Yields: +---------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------------------+-------+ | when | datetime | | | 0000-00-00 00:00:00 | | | host | varchar(255) | | | | | | method | varchar(4) | | | | | | url | varchar(255) | | | | | | auth | varchar(50) | YES | | NULL | | | referer | varchar(255) | YES | | NULL | | | status | smallint(3) | YES | | 0 | | | bytes | int(8) | YES | | NULL | | +---------+--------------+------+-----+---------------------+-------+ Note: since when is a reserved word in MySQL you'll have to escape it with backticks. This isn't explained in the Eagle book. This is a good tutorial. However, please give credit where its due if you used a book or another article as a reference to write it. BMaximus In reply to Re: Web Logs Using DBI
by BMaximus
|
|