MySQL Forums
Forum List  »  Connector/Python

Re: Code not working
Posted by: stefan sonnenberg
Date: July 28, 2006 03:41AM

Shouldn't it be somthing like this :

CREATE TABLE blenders(
productID CHAR(10),
reviewerID CHAR(10),
date CHAR(10),
reviewtype CHAR(10),
filename CHAR(10),
productrating CHAR(10),
easeofuse CHAR(10),
easeofcleaning CHAR(10),
durability CHAR(10),
style CHAR(10),
pros CHAR(10),
cons CHAR(10),
contents CHAR(10))

e.g. adding the number of chars ?
Perhaps MySQL assumes you like to store only 0 chars.

See this:
http://dev.mysql.com/doc/refman/5.1/en/char.html

What does "e" contain, or is the exception never thrown on this ?

Options: ReplyQuote


Subject
Written By
Posted
June 05, 2006 10:42AM
Re: Code not working
July 28, 2006 03:41AM
July 29, 2006 09:48PM
July 30, 2006 02:25PM
August 29, 2006 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.