Error 1050 entering data in Xampp

[Sbbshs]

What should I do when I want to enter database data into Zamp?
Error
SQL query: Copy


--
-- Database: city
--

-- --------------------------------------------------------

--
-- Table structure for table accounts
--

CREATE TABLE accounts (
id int(11) NOT NULL,
username text DEFAULT NULL,
password varchar(32) NOT NULL,
salt varchar(30) NOT NULL DEFAULT '1234567890',
email varchar(100) NOT NULL,
registerdate text DEFAULT NULL,
lastlogin datetime DEFAULT NULL,
ip text DEFAULT NULL,
admin float NOT NULL DEFAULT 0,
supporter float NOT NULL DEFAULT 0,
vct float NOT NULL DEFAULT 0,
mapper float NOT NULL DEFAULT 0,
scripter float NOT NULL DEFAULT 0,
warn_style int(1) NOT NULL DEFAULT 1,
hiddenadmin tinyint(3) UNSIGNED DEFAULT 0,
adminjail tinyint(3) UNSIGNED DEFAULT 0,
adminjail_time int(11) DEFAULT NULL,
adminjail_by text DEFAULT NULL,
adminjail_reason text DEFAULT NULL,
muted tinyint(3) UNSIGNED DEFAULT 0,
globalooc tinyint(3) UNSIGNED DEFAULT 1,
friendsmessage varchar(255) NOT NULL[...]
MySQL said: Documentation

#1050 - Table '`city`.`accounts`' already exists

[Altrea]

if you want to add data to a database table, a CREATE TABLE statement is the wrong one

[Sbbshs]

Sorry I did not understand your answer, I mean I have to give a ticket somewhere else Or did you answer here? Can you say more clearly?

[Altrea]

A create table statement is for creating a database table, the structure to tell the database management system what type of data you want to store.
A database table needs to have a unique name. you tried to create the database table a second time with the same name.

[Nobbie]

You try to create a table which already exists. Thats all.

[Froosh]

I think you want to use an insert statement to add data to an existing table. You may want to read up on MySQL and the different database operations. In my thinking, if you are not up on manipulating a database directly, it is probably not the best approach to adding (or updating) data.