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','rkelley0@soundcloud.com','Female','Computers','10/2/2009',67470,'Structural Engineer',2);
insert into staff values (2,'Armstrong','sarmstrong1@infoseek.co.jp','Male','Sports','3/31/2008',71869,'Financial Advisor',2);
insert into staff values (3,'Carr','fcarr2@woothemes.com','Male','Automotive','7/12/2009',101768,'Recruiting Manager',3);
insert into staff values (4,'Murray','jmurray3@gov.uk','Female','Jewelery','12/25/2014',96897,'Desktop Support Technician',3);
.
.
.
.
.
1000 observations

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
159
January 02, 2020 04:16AM
86
January 02, 2020 12:31PM
Re: MySQL Workbench
65
January 04, 2020 05:22AM
72
January 04, 2020 10:34AM
66
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.