i want to use mysql for logging perposes ...
the database will be accessed by a third party product using ODBC
the problem:
i'll have to create some columns with special characters in the column names
example:
create table PacketFilterLog (
PFlogDate datetime,
PFlogTime datetime,
SourceAddress varchar(25),
DestinationAddress varchar(25),
Protocol varchar(8),
`Param#1` varchar(8),
`Param#2` varchar(8),
TcpFlags varchar(255),
FilterRule varchar(16),
Interface varchar(25),
IPHeader varchar(255),
Payload varchar(255)
);
the proplem resides in:
`Param#1` varchar(8),
`Param#2` varchar(8),
mysql 4.0.16-nt does not accept these column names (and they have to be this way!)
looking at the mysql reference http://www.mysql.com/doc/en/Legal_names.html
this actually should work ...
any idea ?