File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes how set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how set "default" inthe name of column ?" Watch "how set "default" inthe name of column ?" New topic

how set "default" inthe name of column ?

amir taghvayi
Ranch Hand

Joined: Sep 16, 2011
Posts: 54
i try to run this code :

i get sql error near "`defualt` tinyint(1) NOT NULL default '0'," .

please help me !!!
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Since it's a numeric type, have tried "default 0" without the quotes around '0'.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: how set "default" inthe name of column ?
It's not a secret anymore!