i realize how lame this is...
Posted 29 March 2003 - 07:03 AM
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):
This is what I am trying to do:
this is how I am trying to do it
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
please help its late and I am already balding :wink: :roll:
Posted 29 March 2003 - 08:08 AM
If so, the syntax is like this:
ALTER TABLE tbl ADD colName FIELDTYPE;
Hope that helps.
Posted 29 March 2003 - 02:42 PM
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
Posted 29 March 2003 - 03:44 PM
The DB columns are shown horizontally in this view ...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users