4/11/2023 0 Comments Error code 1064 mysql workbench![]() Third, the syntax for the FOREIGN KEY constraint is incorrect. You need to include the manager_id as a column. Try this: mysql -version echo select 1 as WORKING > test.sql. Second, you are trying to add an index on a column that is not listed in your waiters table. It is possible that your MySQL command is an alias or is a client from a different version. The column to be indexed should be inside the parentheses - INDEX (manager_id ). I see a few issues with your existing code to create the waiters table.įirst, the index creation code is incorrect. ![]() I got this error code when executing:Įrror Code: 1064 You have an error in your SQL syntax ERROR 1064 (42000): You have an error in your SQL syntax check the manual that corresponds to your MariaDB server version for the right syntax to use near. The line causing the problem is this: INDEX `manager_id` () ,Īny ideas? I'm at a loss, the code was generated from an ERD model I made within Workbench so I'm suprised it has a syntax error at all. `waiter_id` INT NOT NULL AUTO_INCREMENT , `manager_id` INT NOT NULL AUTO_INCREMENT ,ĭROP TABLE IF EXISTS `waitronmain`.`waiters` ĬREATE TABLE IF NOT EXISTS `waitronmain`.`waiters` ( DROP TABLE IF EXISTS `waitronmain`.`managers` ĬREATE TABLE IF NOT EXISTS `waitronmain`.`managers` ( No error if I remove VISIBLE but MySQL Workbench 8.0. SphinxQL is not fully compatible with MySQL, e.g. CREATE UNIQUE INDEX uuidUNIQUE ON setting (uuid ASC) VISIBLE Error in query (1064): Syntax error near VISIBLE at line 1. ![]() ![]() It is saying that there is a syntax error new '). ERROR 1064 (42000): sphinxql: syntax error, unexpected CONSTINT. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |