File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
jQuery in Action, 3rd edition