Declare a table as like MS SQL Server
Posted by:
Ra Nala
Date: January 03, 2018 11:35AM
Hi,
we are migrating reports from MS SQL Server reports to MySQL innoDB , 5.7.11 version.
i am trying to declare a table in MySQL database as like syntax exist in ms sql server. Could you please help me how can we create in MySQL.
ms sql server syntax
DECLARE @RPRT_DEF_WAR TABLE
(RPRT_ID INT,
SER VARCHAR (50),
MODEL VARCHAR (50),
P_NM VARCHAR (50)
);
Thank you
Subject
Views
Written By
Posted
Declare a table as like MS SQL Server
1041
January 03, 2018 11:35AM
677
January 03, 2018 12:09PM
643
January 03, 2018 01:02PM
537
January 03, 2018 04:02PM
946
January 04, 2018 11:49AM
727
January 04, 2018 12:35PM
653
January 04, 2018 01:03PM
812
January 04, 2018 05:15PM
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.