Consider revising your question so that it appeals to a broader audience. but I may be wrong as said earlier im new to sql stuff. Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. cause I don't think SQL script could be wrong because its been used here as a backup. What I'm gathering from this information is SQL script is different version maybe older than execution method I'm following. Incorrect syntax near the keyword 'with'. If this " ()Ī was thrown: "Incorrect syntax near '`'. This pane can be activated in the View menu, or by using shortcuts Ctrl+\ and Ctrl+E The Error List pane displays syntax and semantic errors found in the query editor. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Label names must be unique within a query batch or stored procedure. The label 'parts' has already been declared. Im getting following exception Exception:Thrown: "Incorrect syntax near '`'. ) ENGINE=InnoDB AUTO_INCREMENT=485 DEFAULT CHARSET=latin1 ĭatabase is big so i suppose i dont need to post all of it. `sort_order` int(11) NOT NULL DEFAULT '0', `lable_id` int(11) NOT NULL AUTO_INCREMENT, *!40101 SET character_set_client = utf8 */ Table structure for table `label_fields` *!40101 SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ ĬREATE DATABASE /*!32312 IF NOT EXISTS*/ `podcat` /*!40100 DEFAULT CHARACTER SET latin1 */ SqlCommand cmd = new SqlCommand(script, conn) įollowing is first table script of sql file - MySQL dump 10.16 Distrib 10.1.21-MariaDB, for Win32 (AMD64) SqlConnection conn = new SqlConnection(sqlConnectionString) String script = file.OpenText().ReadToEnd() I'm using following SMO procedures and code is following string sqlConnectionString = file = new FileInfo("podcat-22-06-2022.sql") I want to read data from this dump file and make a sqlite(offline) database. I'm trying to execute a SQL script dump file which have multiple tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |