Member Avatar for vedro-compota

Hello))
I have a text file with a script that can be used to create an Oracle database, but I want to use this script to create MySQL one) Unfortunately, not all commands are similar. I've already changed the commands for creating tables. And now I can not understand how to be. Tell me please analog command for the MySQL . This one has the following appearance in the Orcl =

insert into STUDENT (STUDENT_ID, SURNAME, NAME, STIPEND, KURS, CITY, BIRTHDAY, UNIV_ID) values (1, 'Stonester', 'Serg', 520, 1, 'London', to_date('21-03-1983', 'dd-mm-yyyy'), 39);

and this's table for which value is added (i've adapted it for mysql) =

create table STUDENT
(
  STUDENT_ID NUMERIC not null,
  SURNAME    VARCHAR(60),
  NAME       VARCHAR(60),
  STIPEND    NUMERIC(16,2),
  KURS       NUMERIC,
  CITY       VARCHAR(60),
  [B]BIRTHDAY   DATE,[/B]
  UNIV_ID    NUMERIC
);

Thank you in advance ))

Edited by vedro-compota because: n/a
  • 1 Contributor
  • 1 Reply
  • 66 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by vedro-compota
Member Avatar for vedro-compota

I think something like this will be right =

[B][U]STR_TO_DATE(str,format)[/U][/B] is the inverse of the DATE_FORMAT() function

Now I will try

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.