TSQL To Maria DB
I am trying to load data from TSQL Into Mysql/Maria DB. I get an autamic warning when trying to create the destination table about manually edit data types for destination table. I looked at the TSQL n Maria DB data types. I changed it from
CREATE TABLE "ADO NET Destination" (
"uid" BIGINT,
"order_uid" BIGINT,
"product_uid" BIGINT,
"label" NVARCHAR(150),
"selling_unit" NVARCHAR(80),
"price" NVARCHAR(10),
"quantity" NVARCHAR(10),
"amended_quantity" NVARCHAR(10),
"adjusted_quantity" NVARCHAR(30),
"margin" NVARCHAR(30),
"out_of_stock" NVARCHAR(1),
"comments" NVARCHAR(250),
"edi_cost_price" NVARCHAR(50),
"edi_rsp" NVARCHAR(50),
"edi_promo_price" NVARCHAR(50),
"picked" NVARCHAR(1),
"oos_qty" INT
)
To
CREATE TABLE "ADO NET Destination" (
"uid" BIGINT,
"order_uid" BIGINT,
"product_uid" BIGINT,
"label" VARCHAR(150),
"selling_unit" VARCHAR(80),
"price" VARCHAR(10),
"quantity" VARCHAR(10),
"amended_quantity" VARCHAR(10),
"adjusted_quantity" VARCHAR(30),
"margin" VARCHAR(30),
"out_of_stock" VARCHAR(1),
"comments" VARCHAR(250),
"edi_cost_price" VARCHAR(50),
"edi_rsp" VARCHAR(50),
"edi_promo_price" VARCHAR(50),
"picked" VARCHAR(1),
"oos_qty" INT
)
I get an error, please assist?
mdbmdb2
Answer Answered by Ian Gilfillan in this comment.
You need to correctly quote your statement, either with the backtick character, or by setting ANSI_QUOTES SQL_MODE, see Identifier Names.