Topic: i realize how lame this is...

[-=harry=-]

same old newbie jabber... I\'m just trying to teach my self mySQL and i\'ve run into a problem, i am very sure it is very simple
I have my database, in my database I have tables
I want to add another row to this table.
This is how it currently looks (kinda):
hotchson_com
--->foing_genres
------->genre_id
------->genre_name

This is what I am trying to do:
hotchson_com
--->foing_genres
------->genre_id
------->genre_name
------->artist_id

this is how I am trying to do it

INSERT (
   artist_id smallint(6) NOT NULL default \'0\'
);

it\'s not working... this is not the only statement I have attempted, I have tried many, I\'m just getting kinda tired of seeing the error screen in phpmyadmin.

the only one I had any luck with was

CREATE TABLE  \'artist_id\' (
   smallint(6) NOT NULL default \'0\'
);

but this gave me

hotchson_com
--->artist_id
--->foing_genres

please help its late and I am already balding  :wink:  :roll:                    

[metalblend]

Do you mean you\'re trying to add another column?
If so, the syntax is like this:

Code: [Select]

ALTER TABLE tbl ADD colName FIELDTYPE;

Hope that helps.                    

[-=harry=-]

no, I don\'t think so  :oops: but I might be mistaken..  when you say column I think of a verticle column being put into the tabe.  what I want to do is add a row



I want to be able to add a row under

genre_name  varchar(32)   No    

and I need it to be

artist_id smallint(6) Null no Default 0                    

[vhkristof]

I believe that is what Metalblend is saying ...
The DB columns are shown horizontally in this view ...                    

[-=harry=-]

ok, cool thanks a lot.
I got it.  :roll:                    

[metalblend]

no problem.