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
74
January 02, 2020 04:16AM
36
January 02, 2020 12:31PM
28
January 04, 2020 05:22AM
34
January 04, 2020 10:34AM
27
January 05, 2020 10:58PM


Sorry, only registered users may post in this forum.

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.