MySQL Forums
Forum List  »  MySQL Workbench

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

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Workbench
636
January 02, 2020 04:16AM
341
January 02, 2020 12:31PM
373
January 04, 2020 05:22AM
312
January 04, 2020 10:34AM
256
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.