Hi,
I have a database called "mymarket".
I create a table called categories:
create table categories (
id int auto_increment not null,
parent_id int not null,
name varchar(25) not null,
description varchar(255) not null,
primary key (id),
index parent_id (parent_id),
index nam (name)
);
When I run mysql> show tables; it's ok, it show me that the table categories was created.
I make records in this table:
mysql> insert into categories (id,parent_id,name,description)
-> values(0,0,'Tip1','Some text.');
When a want to see what the table contains:
mysql>select * from categories;
I receive an Error1030: Got error 127 from table handler.
Please, do you know what error it is?
Many thanks
