posted 5 years ago
Hi Ron and Campbell,
I changed according your suggestions but still get the same error but near aptno : Please see the code below: Can I use Number data type for phone and houseno.?
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 'number(15) default NULL,
`city` varchar(15) default NULL,
`state` varchar(2) def' at line 9
SQL Statement:
CREATE TABLE `jj`.`jjform` (
`fname` varchar(25) default NULL,
`lname` varchar(25) default NULL,
`cname` varchar(10) default NULL,
`addno` int(10) default NULL,
`dir` varchar(25) default NULL,
`street` varchar(50) default NULL,
`type` varchar(10) default NULL,
`aptno` number(15) default NULL,
`city` varchar(15) default NULL,
`state` varchar(2) default NULL,
`zip` varchar(5) default NULL,
`hphone`number(10) default NULL,
`wphone` number(10) default NULL,
`cphone` number(10) default NULL,
`email` varchar(50) default NULL,
`immanual` varchar(10) default NULL,
`residence` varchar(10) default NULL,
`residence1` varchar(10) default NULL,
`recruitment` varchar(25) default NULL,
`recruitment1` varchar(25) default NULL,
`ads` varchar(3) default NULL,
`pinetree` varchar(8) default NULL,
`homecare` varchar(8) default NULL,
`none1` varchar(4) default NULL,
`month1` varchar(15) default NULL,
`day1` varchar(2) default NULL,
`year1` varchar(4) default NULL,
`male` varchar(4) default NULL,
`female` varchar(6) default NULL,
`cob` varchar(20) default NULL,
`cob1` varchar(20) default NULL,
`ability` varchar(10) default NULL,
`ability1` varchar(10) default NULL,
`preference` varchar(10) default NULL,
)