----- Original Message ----- From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 10:31 PM Subject: another newb question for you help...
> Hi again, I'm inserting some test products into my new mysql database but > it only lets me enter so much? I thought BLOB would allow alot more > characters? Anyway, this was how I constructed the database..... > > CREATE TABLE jspCart_products ( > ProductID int primary key, > CategoryID int, > ModelNumber varChar(75), > ModelName varChar(250), > ProductImage varchar(250), > UnitCost decimal(9,2), > Description BLOB, > ); > > This is what I am trying to enter... > INSERT into jspCart_products VALUES(188, 4, "f23", > "modelxyz","../images/product1.jpg", 20.95,"Hi my name is frank and I'd > like to say like WOW man.This is a lengthy description of this product. It > is A numero Uno on my list like wow I love this product so much it is > unbelievable!"); > > But it only lets me type in the command window this much.... > INSERT into jspCart_products VALUES(188, 4, "f23", > "modelxyz","../images/product1.jpg", 20.95,"Hi my name is frank and I'd > like to say like WOW man.This is a lengthy description of this product. > > Can someone help me out here? Your immediate question is essentially about the longest command that you can type at the command line; I'm not really sure of the answer. I very rarely do long commands like that from the command line. However, just for the heck of it, I just signed on the MySQL and got to a command prompt. I found that you can make the command pretty much as long as you like: just press enter whenever you're running out of room and a new line with a new '->' prompt will appear for you to write the next part of your command. End your statement with a semicolon, press Enter and the continuation prompts will stop and your statement will execute. Now, *please* tell me that you don't propose to populate your entire table this way and that you are just trying to create a couple of rows from the command line so that you know how to do it.... I don't think anyone with any pretensions of being professional would populate anything but the tiniest test table via the command line. Put your data into a flat file - or export it into a flat file from wherever it is now - and use the LOAD DATA utility to populate your table. You can build scripts that include the LOAD DATA command plus whatever SQL you need to create and/or verify the contents of your table; creating and running the script will only take you a few minutes once you get on to the technique and be a LOT less painful - and less error-prone - than writing individual INSERT statements for every row in your table. I can post some examples if you're not sure what I mean. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]