File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes how set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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: 3716

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

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: how set "default" inthe name of column ?