MySQL Forums
Forum List  »  MySQL Workbench

MySQL Workbench
Posted by: Shibin Kumar
Date: January 02, 2020 04:16AM


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','','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 ?

Options: ReplyQuote

Written By
MySQL Workbench
January 02, 2020 04:16AM
January 02, 2020 12:31PM
January 04, 2020 05:22AM
January 04, 2020 10:34AM
January 05, 2020 10:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.