Re: field types syntax
Posted by:
Rick James
Date: March 23, 2009 01:03AM
Go back to square 0. Study the syntax in the manual. It does not include "<20>". Optionally you can say "(20)". Nor do you put an INSERT _statement_ in the middle of a CREATE TABLE statement. Parens are not needed (not allowed?) around UNSIGNED and other modifiers. tbl_Books -> Books. Etc.
Let's start with the exact text of your CREATE TABLE (after making the suggested fixes above. Please use [ code ] and [ / code ] around any code, SQL or output.
Subject
Written By
Posted
Re: field types syntax
March 23, 2009 01:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.