File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

how set "default" inthe name of column ?

amir taghvayi
Ranch Hand

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



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

please help me !!!
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

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: http://aspose.com/file-tools
 
subject: how set "default" inthe name of column ?