MySQL Workbench
Hi,
I am trying to create a table with the following details
create table staff
(
id integer,
last_name varchar(100),
email varchar(200),
gender varchar(10),
department varchar(100),
start_date date,
salary integer,
job_title varchar(100),
region_id int,
primary key (id)
);
However I have 1000 observations which has the date in the format MM/DD/YYYY.
Example:insert into staff values (1,'Kelley','rkelley0@soundcloud.com','Female','Computers','10/2/2009',67470,'Structural Engineer',2);
When i try to insert the value i get the following error:
Error Code: 1292 Incorrect Date Value: '10/2/2009'
Can someone help me with a solution to insert the 1000 observations and create the required table ?