Jump to content

Archived

This topic is now archived and is closed to further replies.

-=harry=-

i realize how lame this is...

Recommended Posts

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:

Share this post


Link to post
Share on other sites

Do you mean you\'re trying to add another column?

If so, the syntax is like this:

ALTER TABLE tbl ADD colName FIELDTYPE;

 

Hope that helps.

Share this post


Link to post
Share on other sites

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

 

tabe.jpg

 

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

Share this post


Link to post
Share on other sites

I believe that is what Metalblend is saying ...

The DB columns are shown horizontally in this view ...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.