MySQL Forums
Forum List  »  MySQL Workbench

Re: script error
Posted by: David Childers
Date: October 14, 2021 07:48AM

Here's a translation of your CREATE TABLE statement. You might want to try it, but no guarantees it will work:

CREATE TABLE Customers (Customer# SMALLINT, LastName VARCHAR(10) NOT NULL, FirstName VARCHAR(10) NOT NULL, Address VARCHAR(20), City VARCHAR(12), State VARCHAR(2), Zip VARCHAR(5), Referred SMALLINT, Region CHAR(2), CONSTRAINT customers_customer#_pk PRIMARY KEY(customer#), CONSTRAINT customers_region_ck CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')) );

Options: ReplyQuote


Subject
Views
Written By
Posted
144
October 04, 2021 03:06PM
64
October 04, 2021 05:15PM
90
October 06, 2021 11:34AM
Re: script error
36
October 14, 2021 07:48AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.