GeeCON Prague 2014*
The moose likes JDBC and the fly likes CREATE DOMAIN sql sytax error / is this valid? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "CREATE DOMAIN sql sytax error / is this valid?" Watch "CREATE DOMAIN sql sytax error / is this valid?" New topic
Author

CREATE DOMAIN sql sytax error / is this valid?

Marvin Harrison
Greenhorn

Joined: Mar 03, 2005
Posts: 20
hello, have done brief searches, and have found documentation on this command, but do not know if it is current.

just started jdbc/sql and one of the first things stated is:
CREATE DOMAIN name_me AS CHAR(5) CHECK (VALUE IS NOT NULL);

however, i've got mysql installed and get syntax erros with this....completely confused, can do all other mysql commands as far as i know, creating/dropping/reenaming/etc.

Thank you!
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30598
    
154

"java sojava",
We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks,
Jeanne
Forum Bartender


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
GeeCON Prague 2014
 
subject: CREATE DOMAIN sql sytax error / is this valid?