vutharadi prathyusha

vutharadi prathyusha

  • 1.8k
  • 18
  • 13.9k

Syntax error in MySql

Aug 17 2015 1:53 AM
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 

Answers (5)