List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:January 22 2002 3:13pm
Subject:Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'
View as plain text  
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' 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      VARCHAR(255),
>  month     VARCHAR(255),
>  fak       VARCHAR(255),
>  id        VARCHAR(255),
>  publ      VARCHAR(255),
>);
>
>
>


Thread
ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'Darryl Luff17 Jan
Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'Darryl Luff17 Jan
Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'Johan Hallenberg - LUB NetLab21 Jan
  • Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'Gerald Clark22 Jan
Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'Johan Hallenberg - LUB NetLab21 Jan