MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Declare a table as like MS SQL Server
179
January 03, 2018 11:35AM
111
January 03, 2018 01:02PM
220
January 04, 2018 11:49AM


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.