8 messages in com.mysql.lists.mysqlRe: Small error not sure what is up
FromSent OnAttachments
Bob Ren07 Jul 2000 00:29 
Paul DuBois07 Jul 2000 04:47 
Nancy Whittley07 Jul 2000 05:38 
Curtis Maurand07 Jul 2000 05:45 
Cary Collett07 Jul 2000 05:55 
Nancy Whittley07 Jul 2000 06:12 
Nancy Whittley07 Jul 2000 06:43 
sin...@mysql.com07 Jul 2000 06:58 
Subject:Re: Small error not sure what is up
From:Nancy Whittley (jnwh@fuse.net)
Date:07/07/2000 06:43:27 AM
List:com.mysql.lists.mysql

UPDATE: I went in and changed the name of the column to descript, and it accepted the data just fine. So wonder what is up with that column name. Through phpMyAdmin it gave me an error telling me there was not column by the name artist_Ttyle and there wasn't it was artist_style and when I tried to go in the old fashioned way and insert the data that way it denied me access to that table.

So I went in and changed the name of the column. And now it is accepting my data!. So any clue as to what that was about?

Nancy

My Previous post:

Ok I did that.. When I asked it to describe the table this is what I got:

Type 'help' for help.

mysql> describe artists;

+-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | uid | int(11) | | PRI | 0 | auto_increment | | password | varchar(32) | | | | | | first_name | varchar(20) | | | | | | last_name | varchar(35) | | | | | | address | varchar(30) | YES | | NULL | | | city | varchar(20) | | | | | | state | char(2) | | | | | | zip | varchar(5) | YES | | NULL | | | url | varchar(60) | YES | | NULL | | | email | varchar(35) | YES | | NULL | | | artists_mediums | tinyblob | YES | | NULL | | | artist_style | tinyblob | YES | | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 12 rows in set (0.00 sec)

Ok mind you I may have these set up incorrectly for what I want to do, but they all accept data except the last one, and it still gives this error

MySQL said: Unknown column 'artist_Ttyle' in 'field list'

I am using phpMyAdmin could this be a bug in either this admin panel or with the database? It seems to be interpreting my artist_style as artist_Ttyle this seems strange.

Nancy

describe <tablename>;

it will give you a rundown of all your columns. If its not there then run:

alter table <tablename> add column artist_style <column definition>;

--

--------------------------------------------------------------------- Please check "http://www.mysql.com/php/manual.php3" before posting. To request this thread, e-mail mysq@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-jnwhittley=fuse@lists.mysql.com>