![]() ![]() 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 4 0. Table `blog`.`medias` - CREATE TABLE IF NOT EXISTS `blog`. BEGIN declare vpcid varchar (20) END ERROR: CREATE PROCEDURE UpdateProductConfiguration () BEGIN DECLARE vpcid VARCHAR (20) Error Code: 1064. UNIQUE INDEX `name_UNIQUE` ( `name` ASC ) VISIBLE ) ENGINE = InnoDB `configs` ( `id` INT NOT NULL AUTO_INCREMENT, Table `blog`.`configs` - CREATE TABLE IF NOT EXISTS `blog`. INDEX `fk_posts_users1_idx` ( `user_id` ASC ) VISIBLE ) ENGINE = InnoDB `posts` ( `id` INT NOT NULL AUTO_INCREMENT, So follow along and learn more about what the 1064 error is, some likely causes, and general troubleshooting steps. The FOREIGN KEY constraint prevents invalid data from being inserted into the foreign key column, because it has to be one of the values contained in the parent. Table `blog`.`posts` - CREATE TABLE IF NOT EXISTS `blog`. The 1064 error displays any time you have an issue with your SQL syntax, and is often due to using reserved words, missing data in the database, or mistyped/obsolete commands. `users` ( `id` INT NOT NULL AUTO_INCREMENT, Table `blog`.`users` - CREATE TABLE IF NOT EXISTS `blog`. ![]() Schema blog - Schema blog - CREATE SCHEMA IF NOT EXISTS `blog` DEFAULT CHARACTER SET utf8 SET SQL_MODE= 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' MySQL Script generated by MySQL Workbench - Sat Feb 23 20:46:10 2019 - Model: New Model Version: 1.0 - MySQL Workbench Forward Engineering SET UNIQUE_CHECKS= 0 Sometimes when the data get lost from the SQL database and that data is required for the execution of the query errors 1064 is generated.
0 Comments
Leave a Reply. |