It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Problem With Creating Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem With Creating Table " Watch "Problem With Creating Table " New topic

Problem With Creating Table

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
Hi, I tried to create a table. This table has
seventeen fields. My create table syntax gets too long and I was only able to specify 5 fields at the mysql prompt in the DOS window (DOS does not accept a command beyond certain length). How do I put the rest 12 fields in the table I just created?
mysql>CREATE TABLE message_thread (thread_id INTEGER NOT NULL UTO_INCREMENT PRIMARY KEY, message_receiver VARCHAR(79) NOT NULL, message_sender VARCHAR(79) NOT NULL, article_title VARCHAR(255) NOT NULL, last_post_member_name VARCHAR(79) NOT NULL);
only five fields were able to fit there.
Krishna Mohan
Ranch Hand

Joined: May 30, 2003
Posts: 44
Use this tool MySQLCC.
You can download it from here.
Hope that helps.
[ December 31, 2003: Message edited by: Krishna Mohan ]

Programming is Fun.
I agree. Here's the link:
subject: Problem With Creating Table
It's not a secret anymore!