"DROP TABLE c0053631_PRODUCT;",
"CREATE TABLE c0053631_PRODUCT (
PROD_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
PROD_TITLE TEXT,
PROD_DESC TEXT,
PROD_PRICE INT NOT NULL,
PROD_ISBN VARCHAR,
PROD_AUTHOR TEXT
);"
);
i try to create the above table using the above code, but when i execute it it says that there is an in my sql syntax here:
PROD_AUTHOR TEXT
);"
thing is i've used the same code before but with less tables and it worked fine.
