[RESOLVED] Fix with the creation of a table

[bumbar]

Hallo!

This is my issue with producing a table. The code uses it from textbook.

I use phpMyAdmin,
MySQL Server version: 5.0.45

This is

 CREATE TABLE 'category'(
'category_id 'INT NOT NULL AUTO_INCREMENT ,
'department_id' INT NOT NULL ,
'name'VARCHAR( 100 ) NOT NULL ,
'description'VARCHAR( 1000 ) ,
PRIMARY KEY ( 'category_id' ) ,
KEY 'idx_category_department_id'( 'department_id' )
) ENGINE = MYISAM

I Receive a error message:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''category' (
'category_id' INT NOT NULL AUTO_INCREMENT,
'department_id' INT NO' at line 1

Where the mistake is?

Thanx!

[Lars_Berg]

CREATE TABLE category(
category_id INT NOT NULL AUTO_INCREMENT ,
department_id INT NOT NULL ,
name VARCHAR(100) NOT NULL ,
description VARCHAR(1000) ,
PRIMARY KEY (category_id) ,
KEY idx_category_department_id(department_id)
) ENGINE = MYISAM 

[bumbar]

You have my thankses!!!🙂