----- 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]

Reply via email to