Syntax error in MySql

Question

Hi Iam new to mysql currently i working on My Sql workbench.How to insert values into table by using Stored procedures iam getting errors i didn't understand what i made mistakes if any one please help me.This are my table values. CREATE TABLE magazine( Id INT NOT NULL AUTO_INCREMENT OrderId INT NOT NULL PRIMARY KEY PackageId INT NOT NULL Status VARCHAR(20) NOT NULL GiftGiverName VARCHAR(50) NOT NULL GiftGiverEmail VARCHAR(20) NOT NULL ReceipentFirstName VARCHAR(50) NOT NULL ReceipentLastName VARCHAR(50) NOT NULL ReceipentGender VARCHAR(20) NOT NULL SpecialOccassionDescription VARCHAR(40) NOT NULL Title VARCHAR(20) NOT NULL CoverPhoto VARCHAR(20) NOT NULL DeliveryDate VARCHAR(20) NOT NULL Guid VARCHAR(20) NOT NULL MessageToContributors VARCHAR(20) NOT NULL CreatedOn DATE ); Thanks Prathyusha

Sandeep Kumar · Answer

Hello You almost well written your code but because of minor mistakes it will not work. 1. like as you used (comma) in last of your query statement so it makes that you are now going to write another one query so don't use (comma) in last of your query. 2. In mysql there is only one auto_increment field provided which is used for primary key you can't differ them. the updated query is as follows :- CREATE TABLE magazine( Id INT NOT NULL OrderId INT NOT NULL PRIMARY KEY AUTO_INCREMENT PackageId INT NOT NULL Status VARCHAR(20) NOT NULL GiftGiverName VARCHAR(50) NOT NULL GiftGiverEmail VARCHAR(20) NOT NULL ReceipentFirstName VARCHAR(50) NOT NULL ReceipentLastName VARCHAR(50) NOT NULL ReceipentGender VARCHAR(20) NOT NULL SpecialOccassionDescription VARCHAR(40) NOT NULL Title VARCHAR(20) NOT NULL CoverPhoto VARCHAR(20) NOT NULL DeliveryDate VARCHAR(20) NOT NULL Guid VARCHAR(20) NOT NULL MessageToContributors VARCHAR(20) NOT NULL CreatedOn DATE );

Upendra Pratap Shahi · Answer

Hello Use this query- CREATE TABLE magazine ( Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY  OrderId INT  PackageId INT NOT NULL Status VARCHAR ( 20 ) NOT NULL GiftGiverName VARCHAR ( 50 ) NOT NULL GiftGiverEmail VARCHAR ( 20 ) NOT NULL ReceipentFirstName VARCHAR ( 50 ) NOT NULL ReceipentLastName VARCHAR ( 50 ) NOT NULL ReceipentGender VARCHAR ( 20 ) NOT NULL SpecialOccassionDescription VARCHAR ( 40 ) NOT NULL Title VARCHAR ( 20 ) NOT NULL CoverPhoto VARCHAR ( 20 ) NOT NULL DeliveryDate VARCHAR ( 20 ) NOT NULL Guid VARCHAR ( 20 ) NOT NULL MessageToContributors VARCHAR ( 20 ) NOT NULL CreatedOn DATE ); If helped kindly accept the answer.

Manas Mohapatra · Answer

Hi To resolve your issue please see below corrections: 1. You have one extra comma() in last line - remove it. Please change it to CreatedOn DATE 2. You can't have one primary key and another key as auto increment. in your query Id is auto increment and OrderId is primary key. So primary should be auto increment. Please see below updated query: CREATE TABLE magazine( Id INT NOT NULL OrderId INT NOT NULL PRIMARY KEY AUTO_INCREMENT PackageId INT NOT NULL Status VARCHAR(20) NOT NULL GiftGiverName VARCHAR(50) NOT NULL GiftGiverEmail VARCHAR(20) NOT NULL ReceipentFirstName VARCHAR(50) NOT NULL ReceipentLastName VARCHAR(50) NOT NULL ReceipentGender VARCHAR(20) NOT NULL SpecialOccassionDescription VARCHAR(40) NOT NULL Title VARCHAR(20) NOT NULL CoverPhoto VARCHAR(20) NOT NULL DeliveryDate VARCHAR(20) NOT NULL Guid VARCHAR(20) NOT NULL MessageToContributors VARCHAR(20) NOT NULL CreatedOn DATE );