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
694
October 04, 2021 03:06PM
340
October 04, 2021 05:15PM
308
October 06, 2021 11:34AM
Re: script error
287
October 14, 2021 07:48AM


Sorry, you can't reply to this topic. It has been closed.

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.