| Hola... Error MySQL!
Hola... Estoy teniendo un error mysql ( me parece ) trato de llevar a cabo una sentencia hacia una tabla, pero parece, que la tabla no me da permiso... bueno, yo quiero poder leer la tabla
aca esta el php Cita: CREATE TABLE `char` (
`char_id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`char_num` tinyint(4) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`class` int(11) NOT NULL default '0',
`base_level` bigint(20) unsigned NOT NULL default '1',
`job_level` bigint(20) unsigned NOT NULL default '1',
`base_exp` bigint(20) NOT NULL default '0',
`job_exp` bigint(20) NOT NULL default '0',
`zeny` int(11) NOT NULL default '500',
`str` int(11) unsigned NOT NULL default '0',
`agi` int(11) unsigned NOT NULL default '0',
`vit` int(11) unsigned NOT NULL default '0',
`int` int(11) unsigned NOT NULL default '0',
`dex` int(11) unsigned NOT NULL default '0',
`luk` int(11) unsigned NOT NULL default '0',
`max_hp` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`max_sp` int(11) NOT NULL default '0',
`sp` int(11) NOT NULL default '0',
`status_point` int(11) NOT NULL default '0',
`skill_point` int(11) NOT NULL default '0',
`option` int(11) NOT NULL default '0',
`karma` int(11) NOT NULL default '0',
`manner` int(11) NOT NULL default '0',
`party_id` int(11) NOT NULL default '0',
`guild_id` int(11) NOT NULL default '0',
`pet_id` int(11) NOT NULL default '0',
`hair` tinyint(4) unsigned NOT NULL default '0',
`hair_color` int(11) unsigned NOT NULL default '0',
`clothes_color` tinyint(4) unsigned NOT NULL default '0',
`weapon` int(11) NOT NULL default '1',
`shield` int(11) NOT NULL default '0',
`head_top` int(11) NOT NULL default '0',
`head_mid` int(11) NOT NULL default '0',
`head_bottom` int(11) NOT NULL default '0',
`last_map` varchar(20) NOT NULL default 'new_5-1.gat',
`last_x` int(4) NOT NULL default '53',
`last_y` int(11) NOT NULL default '111',
`save_map` varchar(20) NOT NULL default 'new_5-1.gat',
`save_x` int(11) NOT NULL default '53',
`save_y` int(11) NOT NULL default '111',
`partner_id` int(11) NOT NULL default '0',
`online` tinyint(4) NOT NULL default '0',
`father` int(11) NOT NULL default '0',
`mother` int(11) NOT NULL default '0',
`child` int(11) NOT NULL default '0',
`fame` int(11) NOT NULL default '0',
PRIMARY KEY (`char_id`),
KEY `party_id` (`party_id`),
KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; Aca esta el sql: Cita: CREATE TABLE `char` (
`char_id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`char_num` tinyint(4) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`class` int(11) NOT NULL default '0',
`base_level` bigint(20) unsigned NOT NULL default '1',
`job_level` bigint(20) unsigned NOT NULL default '1',
`base_exp` bigint(20) NOT NULL default '0',
`job_exp` bigint(20) NOT NULL default '0',
`zeny` int(11) NOT NULL default '500',
`str` int(11) unsigned NOT NULL default '0',
`agi` int(11) unsigned NOT NULL default '0',
`vit` int(11) unsigned NOT NULL default '0',
`int` int(11) unsigned NOT NULL default '0',
`dex` int(11) unsigned NOT NULL default '0',
`luk` int(11) unsigned NOT NULL default '0',
`max_hp` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`max_sp` int(11) NOT NULL default '0',
`sp` int(11) NOT NULL default '0',
`status_point` int(11) NOT NULL default '0',
`skill_point` int(11) NOT NULL default '0',
`option` int(11) NOT NULL default '0',
`karma` int(11) NOT NULL default '0',
`manner` int(11) NOT NULL default '0',
`party_id` int(11) NOT NULL default '0',
`guild_id` int(11) NOT NULL default '0',
`pet_id` int(11) NOT NULL default '0',
`hair` tinyint(4) unsigned NOT NULL default '0',
`hair_color` int(11) unsigned NOT NULL default '0',
`clothes_color` tinyint(4) unsigned NOT NULL default '0',
`weapon` int(11) NOT NULL default '1',
`shield` int(11) NOT NULL default '0',
`head_top` int(11) NOT NULL default '0',
`head_mid` int(11) NOT NULL default '0',
`head_bottom` int(11) NOT NULL default '0',
`last_map` varchar(20) NOT NULL default 'new_5-1.gat',
`last_x` int(4) NOT NULL default '53',
`last_y` int(11) NOT NULL default '111',
`save_map` varchar(20) NOT NULL default 'new_5-1.gat',
`save_x` int(11) NOT NULL default '53',
`save_y` int(11) NOT NULL default '111',
`partner_id` int(11) NOT NULL default '0',
`online` tinyint(4) NOT NULL default '0',
`father` int(11) NOT NULL default '0',
`mother` int(11) NOT NULL default '0',
`child` int(11) NOT NULL default '0',
`fame` int(11) NOT NULL default '0',
PRIMARY KEY (`char_id`),
KEY `party_id` (`party_id`),
KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; Gracias, MZ |