Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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!