Posted by CAH on 10/11/14 11:27

I once wrote on usenet and got a very good answer . This one

JN wrote:
> >| Should one place all the text in one big table, or is i better to place
> >| it in several tabels. Should one make 4 colums one for each language,
> >| or 4 rows one for each language?
>
> I use:
> CREATE TABLE `usr_languages` (
> `pageName` varchar(25) default '',
> `itemNo` int(11) default '0',
> `en` text,
> `fr` text,
> `it` text
> ) TYPE=MyISAM COMMENT='different languages';
>

which I used, and it works just fine, except that I just discovered
that if I place just a litle more than a few line of text - in the TEXT
fields then i get an "error" in phpmyadmin. There is a small question
mark were thre is normally a pen and a cross - and when I move the
cursur above the question mark i get this. "you should define a primary
key for this table" .

Do you have any suggestions as to what the problem might be?

Thanks for any help you can offer.

Best regards
Cah

• Next in forum: Re: php dialog widgets?
• Prev in forum: Re: simplifying repeating database connections in a class?
• Thread view: "you should define a primary key for this table" - why?

[Reply to this message]