0

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: n/a

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by vedro-compota
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.