Re: field types syntax
1064 <42000> near'Insert at line 2 since I entered your code It is always the author social security line I,ve tried int,char,bigint,but it always shows error near either author or security
use Books_at_home;
CREATE TABLE Books
(ISBN Number BIGINT<20> (UNSIGNED) (ZEROFILL) PRIMARY KEY,
Book Title CHAR<45>,
INSERT INTO tbl_Books (..., Author_Social_Security, ...)INT(..., 123456789, ...)(UNSIGNED);
Book_Cost NUMERIC(4,2),
Year Published DATETIME ; but now it shows after insert I have tried brackets and parentheses around into but same error
Subject
Written By
Posted
Re: field types syntax
March 22, 2009 08:56PM
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.