Re: Marc, please make your post titles more informative

[Marc Ray]

my apologies for title. my script gets stuck here...

Executing:
CREATE SCHEMA `new_schema` ;
USE `new_schema` ;

CREATE TABLE PROD_TBL1 (
P_CODE varchar(50),
P_DESCRIPT varchar(50),
PRICE numeric(4,2),
);

Operation failed: There was an error while applying the SQL script to the database.
ERROR 1064: 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 5
SQL Statement:
CREATE TABLE PROD_TBL1 (
P_CODE varchar(50),
P_DESCRIPT varchar(50),
PRICE numeric(4,2),
)


what is the right syntax to use near ')'?

i have other tables that use same format that worked fine