how do i enter data into this table?

ceanth

How would i enter data into this table e.g. insert into ......
I havent seen "tinytext" anywhere before:

CREATE TABLE shopping ( session tinytext NOT NULL, product tinytext NOT NULL, quantity tinytext NOT NULL, card tinytext NOT NULL, id tinyint(4) DEFAULT '0' NOT NULL auto_increment, KEY id (id), PRIMARY KEY (id) );

Any idea?

JL2k

Assuming this is mysql, the query I believe you have to pass is: (Not 100% sure, as I haven't dealt greatly with auto incrementing primary keys, but try it and see!)

insert into shopping values('Tiny text!','baked beans','234','3213132123312');

The one thing I can tell you for sure though, is what tiny text is, basically, tiny text is a small text field, but it's NOT case sensitive. If you want case sensitive, you would use tinyblob.

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB
types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB dier only in the maximum length of
the values they can hold. See Section 6.2.6 [Storage requirements], page 405.
The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT correspond to the four
BLOB types and have the same maximum lengths and storage requirements. The only
dierence between BLOB and TEXT types is that sorting and comparison is performed in
case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other
words, a TEXT is a case-insensitive BLOB.

TINYBLOB, TINYTEXT L+1 bytes, where L < 2⁸
BLOB, TEXT L+2 bytes, where L < 2¹⁶
MEDIUMBLOB, MEDIUMTEXT L+3 bytes, where L < 2²⁴
LONGBLOB, LONGTEXT L+4 bytes, where L < 2³²

So a tinyblob can be 256 bytes (or characters) in length.

Hope that helps!

ceanth

i got this error:

Column count doesn't match value count at row 1

🙁

sanu

try like this
insert into shopping(field1,field2,field3)values(blah,blah,blash);

ceanth

Unknown column 'blah' in 'field list'

any other suggestions? Just to let you guys know this is tables for a shopping cart if that helps

JL2k

Well, you will have to change field 1, 2 and 3 to the field names: session, product, quantity, and card.
Also, the data you are entering: blah, has to be in quotes, so it knows it's not a command, 'blah'.

insert into shopping(session, product, quantity, card) values('tiny text','baked beans','123','321');

ceanth

yup it worked how about this one:

CREATE TABLE inventory ( product tinytext NOT NULL, quantity tinytext NOT NULL, id tinyint(4) DEFAULT '0' NOT NULL auto_increment, description tinytext NOT NULL, price float(10,2) DEFAULT '0.00' NOT NULL, KEY id (id), PRIMARY KEY (id), KEY price (price) );

JL2k

insert into shopping(fieldnames) values(values);

The field names are:
inventory ( product tinytext NOT NULL, quantity tinytext NOT NULL, id tinyint(4) DEFAULT '0' NOT NULL auto_increment, description tinytext NOT NULL, price float(10,2) DEFAULT '0.00' NOT NULL, KEY id (id), PRIMARY KEY (id), KEY price (price) );
The ID field though, it auto-incrementing, so it does not need to be set, so leave that field out.

Remember the fields should be seperated with a comma.

The values are whatever values you want to assign to the fieldname, you should put them in the same order as you put the fieldnames.