Hi everyone,
This is the code to create a new table:
[pre]CREATE TABLE melClans (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
KEY (id)
);[/pre]]
This is an error message I get in response to creating table with the above code:
[pre]#1813 - Tablespace for table '`skullcrashingwords`.`melclans`' exists. Please DISCARD the tablespace before IMPORT[/pre]
Since table already exists I type:
[pre]use skullcrashingwords;
select * from melClans;[/pre]
But I get the following error:
[pre]#1146 - Table 'skullcrashingwords.melclans' doesn't exist[/pre]
Any idea why I'm recieving these contradictory errors ?
Thanks
This is the code to create a new table:
[pre]CREATE TABLE melClans (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
KEY (id)
);[/pre]]
This is an error message I get in response to creating table with the above code:
[pre]#1813 - Tablespace for table '`skullcrashingwords`.`melclans`' exists. Please DISCARD the tablespace before IMPORT[/pre]
Since table already exists I type:
[pre]use skullcrashingwords;
select * from melClans;[/pre]
But I get the following error:
[pre]#1146 - Table 'skullcrashingwords.melclans' doesn't exist[/pre]
Any idea why I'm recieving these contradictory errors ?
Thanks