Sobre a criação do ranking de ragnarok server!

[Gemeos 0]

Bom dia pessoal, tudo bem?

Sou programador de PHP a 4 anos... dei uma parada por 1 ano e voltei novamente a criar websites...

Estou desenvolvendo o website para um servidor de ragnarok, quando faço a seleção da tabela char usando o select * from char, simplesmente da esse erro...

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 'char' at line 1

 

Essa é a estrutura da tabela char.

CREATE TABLE IF NOT EXISTS `char` (

`char_id` int(11) unsigned NOT NULL auto_increment,

`account_id` int(11) unsigned NOT NULL default '0',

`char_num` tinyint(1) NOT NULL default '0',

`name` varchar(30) NOT NULL default '',

`class` smallint(6) unsigned NOT NULL default '0',

`base_level` smallint(6) unsigned NOT NULL default '1',

`job_level` smallint(6) unsigned NOT NULL default '1',

`base_exp` bigint(20) unsigned NOT NULL default '0',

`job_exp` bigint(20) unsigned NOT NULL default '0',

`zeny` int(11) unsigned NOT NULL default '0',

`str` smallint(4) unsigned NOT NULL default '0',

`agi` smallint(4) unsigned NOT NULL default '0',

`vit` smallint(4) unsigned NOT NULL default '0',

`int` smallint(4) unsigned NOT NULL default '0',

`dex` smallint(4) unsigned NOT NULL default '0',

`luk` smallint(4) unsigned NOT NULL default '0',

`max_hp` mediumint(8) unsigned NOT NULL default '0',

`hp` mediumint(8) unsigned NOT NULL default '0',

`max_sp` mediumint(6) unsigned NOT NULL default '0',

`sp` mediumint(6) unsigned NOT NULL default '0',

`status_point` int(11) unsigned NOT NULL default '0',

`skill_point` int(11) unsigned NOT NULL default '0',

`option` int(11) NOT NULL default '0',

`karma` tinyint(3) NOT NULL default '0',

`manner` smallint(6) NOT NULL default '0',

`party_id` int(11) unsigned NOT NULL default '0',

`guild_id` int(11) unsigned NOT NULL default '0',

`pet_id` int(11) unsigned NOT NULL default '0',

`homun_id` int(11) unsigned NOT NULL default '0',

`elemental_id` int(11) unsigned NOT NULL default '0',

`hair` tinyint(4) unsigned NOT NULL default '0',

`hair_color` smallint(5) unsigned NOT NULL default '0',

`clothes_color` smallint(5) unsigned NOT NULL default '0',

`weapon` smallint(6) unsigned NOT NULL default '0',

`shield` smallint(6) unsigned NOT NULL default '0',

`head_top` smallint(6) unsigned NOT NULL default '0',

`head_mid` smallint(6) unsigned NOT NULL default '0',

`head_bottom` smallint(6) unsigned NOT NULL default '0',

`robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',

`last_map` varchar(11) NOT NULL default '',

`last_x` smallint(4) unsigned NOT NULL default '53',

`last_y` smallint(4) unsigned NOT NULL default '111',

`save_map` varchar(11) NOT NULL default '',

`save_x` smallint(4) unsigned NOT NULL default '53',

`save_y` smallint(4) unsigned NOT NULL default '111',

`partner_id` int(11) unsigned NOT NULL default '0',

`online` tinyint(2) NOT NULL default '0',

`father` int(11) unsigned NOT NULL default '0',

`mother` int(11) unsigned NOT NULL default '0',

`child` int(11) unsigned NOT NULL default '0',

`fame` int(11) unsigned NOT NULL default '0',

`rename` SMALLINT(3) unsigned NOT NULL default '0',

`delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (`char_id`),

KEY `account_id` (`account_id`),

KEY `party_id` (`party_id`),

KEY `guild_id` (`guild_id`),

KEY `name` (`name`),

KEY `online` (`online`)

) ENGINE=MyISAM AUTO_INCREMENT=150000;

 

 

Reparei que é so colocar uma tabela com o nome char que da o erro:

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 'char' at line 1

 

Desde ja obrigado.