Re: MySQL Workbench

[Shibin Kumar]

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','[e-mail]','Female','Computers','10/2/2009',67470,'Structural Engineer',2);
insert into staff values (2,'Armstrong','[e-mail]','Male','Sports','3/31/2008',71869,'Financial Advisor',2);
insert into staff values (3,'Carr','[e-mail]','Male','Automotive','7/12/2009',101768,'Recruiting Manager',3);
insert into staff values (4,'Murray','[e-mail]','Female','Jewelery','12/25/2014',96897,'Desktop Support Technician',3);
.
.
.
.
.
1000 observations

Thank you