PRIMARY KEY in mysql 4.0.18

2004-03-17 Thread Geilson Coutinho Figueiredo
Hi, I would like to know what happen when I create an table without a Primary Key. Does MySQL create an hide primary key? Regards, Geilson Coutinho Figueiredo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

LOAD INDEX INTO CACHE problem

2004-03-11 Thread Geilson Coutinho Figueiredo
Hi, I'm trying to load an index into cache hot_cache, but it is not working. Here is my step to step: CREATE TABLE GEILSON (CPF VARCHAR(14) NOT NULL, NAME VARCHAR(75) NOT NULL, PRIMARY KEY (CPF), FULLTEXT (NAME)); INSERT INTO GEILSON (CPF,NAME) VALUES (08238512786, DAVID ESCODINO); INSERT