Jump to content


Photo

i realize how lame this is...


  • Please log in to reply
5 replies to this topic

#1 -=harry=-

-=harry=-
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 March 2003 - 07:03 AM

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:

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 29 March 2003 - 08:08 AM

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.

#3 -=harry=-

-=harry=-
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 March 2003 - 02:42 PM

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

Posted Image

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

#4 vhkristof

vhkristof
  • Members
  • PipPip
  • Member
  • 11 posts
  • LocationAchel, Limburg, Belgium

Posted 29 March 2003 - 03:44 PM

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

#5 -=harry=-

-=harry=-
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 March 2003 - 04:01 PM

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

#6 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 29 March 2003 - 07:02 PM

8) no problem.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users