Re: text base scripts in MyWorkbench

[John Holderman]

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