Error code: 1050 Table & #39; emp & #39; already exists, empexists

Error code: 1050 Table 'emp' already exists, empexists

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: create table emp (id int (8) primary key not null, ename varchar (20) not null, eage int (3), esex varchar (2) error code: 1050 Table 'emp' already exists execution time: 0 sec Transfer Time: 0 sec total time: 0.001 sec

2. Error cause

Execute the SQL statement repeatedly to create a database table

Create table emp (id INT (8) primary key not null, ename VARCHAR (20) not null, eage INT (3), esex VARCHAR (2 ));

3. Solution

(1) do not execute the preceding SQL

(2) If the table has been modified, you can delete the table and then execute the preceding SQL statement; or use the SQL statement to modify the table.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.