Try '=' instead of 'LIKE'.
LIKE is used for wild card pattern matching, which you don't have here.
Johan Hallenberg - LUB NetLab wrote:
>Hello,
>I'm experience the same problem. I use a query like this:
>
>SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND
>month LIKE 'Oct' GR
Hello again,
"ERROR 1169: Can't write, because of unique constraint, to table"
is a bug that have been fixed in release 3.23.44, look at the page
http://www.mysql.com/doc/N/e/News-3.23.44.html .
/Johan
-
Before posting, plea
Hello,
I'm experience the same problem. I use a query like this:
SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND
month LIKE 'Oct' GROUP BY publ,fak,id;
If I remove COUNT(*) I don't get the error.
The table I use look like this:
CREATE TABLE ftxt_stat (
year VARCHA
I have a bit more info. The only thing I could think of that could
create a constraint problem was that the two columns being grouped on
have some data in common.
ie., there could be two records like this:
src dst
=== ===
9.9.9.9 aaa
bbb 9.9.9.9
>From my limited
-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 li