-=harry=- Posted March 29, 2003 Share Posted March 29, 2003 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: Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/ Share on other sites More sharing options...
metalblend Posted March 29, 2003 Share Posted March 29, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/#findComment-833 Share on other sites More sharing options...
-=harry=- Posted March 29, 2003 Author Share Posted March 29, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/#findComment-834 Share on other sites More sharing options...
vhkristof Posted March 29, 2003 Share Posted March 29, 2003 I believe that is what Metalblend is saying ... The DB columns are shown horizontally in this view ... Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/#findComment-836 Share on other sites More sharing options...
-=harry=- Posted March 29, 2003 Author Share Posted March 29, 2003 ok, cool thanks a lot. I got it. :roll: Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/#findComment-837 Share on other sites More sharing options...
metalblend Posted March 29, 2003 Share Posted March 29, 2003 no problem. Quote Link to comment https://forums.phpfreaks.com/topic/277-i-realize-how-lame-this-is/#findComment-839 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.