Can anyone please explain what the subject error means? Full details are
below. Have tried searching and not come up with anything.
Thanks!
Darryl Luff
[EMAIL PROTECTED]
When running this query:
select src as Source, dst as Destination, count(*) as Drops
from data
where (action in ('drop', 'reject'))
group by src, dst
;
on this table:
create table data (
id int unsigned auto_increment primary key,
ldate DATE,
ltime TIME,
ltype varchar(50),
action varchar(50),
proto varchar(50),
src varchar(255),
dst varchar(255),
service varchar(50),
s_port varchar(50),
xlatesrc varchar(255),
xlatedst varchar(255),
reason varchar(255),
icmptype varchar(50),
icmpcode varchar(50),
sysmsgs varchar(50)
);
I get this error:
mysql> \. sql/drops-src-dst.sql
ERROR 1169: Can't write, because of unique constraint, to table
'#sql3aa_a_1'
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php