![]() I also can't change the name of the column, as the column is used in many processes. ![]() I have to add, that the primary field is not a primary key (or any key) field, it just stores the information if specific product is our primary product, or no. However, on Output Data block I have no ability to modify (or even view) the SQL statement and I assume, that this primary field may cause this error (I assume that because the error says something about syntax error. I decided to use Visual Builder then and noticed, that the word primary is written as ` primary` (with this ` backquote/backtick/grave symbols). I've noticed, that when I placed my SQL query in Input Data block (where I wanted to take also primary column as an input), I've received the following error: Here is a generic SQL syntax to create a MySQL table. You can open your database by typing USE database at the MySQL. The issue is taking place in Output Data.) In order to create a table, you must have a database to house it in. (The following paragraph is only a context, thing that gave me an assumption what may cause the issue, not an actual issue. I am updating a column named primary (based on other fields that are a keys. ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram statistics for the named table columns and stores them in the data dictionary. The block was meant to update the MySQL table on our internal database. ![]() This is appearing in the Output Data block. I'm facing below issue in one of my workflows:Įrror: Output Data (46): Error SQLPrepare: You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |