I'm running into a problem in trying to create a MySQL table of 120+ fields.
Perhaps there's a better way to do this, but until now I've used the
Terminal and (after starting MySQL etc) simply pasted my CREATE
statement into the MySQL command line, like:
CREATE TABLE responses (
ticket_id VARCHAR(50) ,
assmt_id SMALLINT UNSIGNED ,
recorded TIMESTAMP(8) ,
assessing VARCHAR(100) ) ;
and it has worked fine. But with this large CREATE statement I find
the Terminal freezes up, and the, well - it used to be a beach ball -
but the 'wait' cursor shows up and nothing happens. I have to 'Force
Quit' to get out of it.
What am I doing wrong here?
Thanks for any assistance,
Nelson
--
