MySQL Forums
Forum List  »  MySQL Workbench

Re: text base scripts in MyWorkbench
Posted by: John Holderman
Date: May 08, 2019 08:47AM

Thanks Mike,

I fully understand that SQL is the language for databases, including MySQL. However, I'm using a text editor to create a command like

CREATE TABLE customer_table (

cust_idx INTEGER(10) AUTO_INCREMENT NOT NULL PRIMARY KEY,
cust_id VARCHAR(10) NOT NULL,
cust_lname VARCHAR(35) NOT NULL,
cust_fname VARCHAR(35) NOT NULL,
cust_mi VARCHAR(1) NOT NULL,
cust_address VARCHAR(100) NOT NULL,
cust_city VARCHAR(25) NOT NULL,
cust_state VARCHAR(2) NOT NULL,
cust_zip INT(5) NOT NULL)

I cannot find a command line editor on MyWorkbench and when I open a script window it wants Python not SQL text.

I open the MtSQL Shell, the prompt is mysql JS>. I switch to sql "\sql" but I can't get anything to work. I know I'm missing something but I can't seem to find it in the manuals.

I just need a bit of help getting started.


John

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: text base scripts in MyWorkbench
222
May 08, 2019 08:47AM


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.