MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote

Written By
March 21, 2009 07:28PM
March 22, 2009 03:26AM
March 22, 2009 12:13PM
March 22, 2009 06:07PM
March 22, 2009 07:14PM
March 22, 2009 08:56PM
Re: field types syntax
March 23, 2009 01:03AM
March 22, 2009 01:01PM

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.