Cannot export mssql data

abduraufsherkulov posted 6 months ago in General

Whenever I try exporting, it is showing SQL error 102 and Incorrect syntax near the keyword "IF".

CREATE TABLE IF NOT EXISTS "USERS" ( "id" INT(10,0) NOT NULL, "client_id" VARCHAR(255) NOT NULL, "username" TEXT(2147483647) NULL DEFAULT NULL, "full_name" TEXT(2147483647) NULL DEFAULT NULL, "state" INT(10,0) NULL DEFAULT ((0)), "lang" VARCHAR(50) NULL DEFAULT ('ru'), "last_selected_location" TEXT(2147483647) NULL DEFAULT NULL, "last_searched_drug" TEXT(2147483647) NULL DEFAULT NULL, "last_limit_from" INT(10,0) NULL DEFAULT ((0)), "last_limit_to" INT(10,0) NULL DEFAULT ((10)), "phone" TEXT(2147483647) NULL DEFAULT NULL, PRIMARY KEY ("id") );

tom andreson posted 6 months ago

dssdfsdfndgsdg

kenorb posted 2 months ago

Same here. Using HeidiSQL v9.5.0.5249 on remote SQL Server via SSL tunnel, then exporting into local Docker container (microsoft/mssql-server-linux).

1 attachment(s):
  • HeidiSQL-bug-25373
kenorb posted 2 months ago

[Local\SL-MSSQL-Docker] CREATE TABLE IF NOT EXISTS "t_zonemap" ( "zmap_no" INT(10,0) NOT NULL, "smap_no" INT(10,0) NOT NULL, "zmap_graphic" NVARCHAR(1000) NULL DEFAULT NULL, PRIMARY KEY ("zmap_no") ); / [Local\SL-MSSQL-Docker] SQL Error (102): Incorrect syntax near the keyword 'IF' Incorrect syntax near 't_zonemap'. /

brownsy posted 2 months ago

Thanks for posting your question as i faced earlier the same error.

Please login to leave a reply, or register at first.