MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL Workbench
Posted by: Shibin Kumar
Date: January 04, 2020 05:22AM

Thank you Peter, However i already have 1000 observations similar to the example. So i have got the data, should i apply the function to all of them.

Is there any way to change the create table command to convert this type of date into the right format.

Please find below the exact script that i have.

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)

insert into staff values (1,'Kelley','','Female','Computers','10/2/2009',67470,'Structural Engineer',2);
insert into staff values (2,'Armstrong','','Male','Sports','3/31/2008',71869,'Financial Advisor',2);
insert into staff values (3,'Carr','','Male','Automotive','7/12/2009',101768,'Recruiting Manager',3);
insert into staff values (4,'Murray','','Female','Jewelery','12/25/2014',96897,'Desktop Support Technician',3);
1000 observations

Thank you

Options: ReplyQuote

Written By
January 02, 2020 04:16AM
January 02, 2020 12:31PM
Re: MySQL Workbench
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.