Inserting a field into a table

[rcastillo]

Using mysql, i've sucessfully created a table with some fields into the database. But, i don't know the command to edit the table and add in another field... anyone know how that is done?

Thanks for your help!!

rc

[tomhath]

Read the manual, or get a book on SQL and read it.

[rcastillo]

thanks for your very rude reply. for your info, i have read the documentation on mysql.com and haven't found anything.

anyone have any suggestions?

thanks,

rc

[rcastillo]

No need to reply. I found the commands I was looking for.

Have a good day everyone...

rc

[themaxx]

These are about the most basic things to know! But I had a hard time learning myself, so I made a text file with some commands. Just remember I don't know what I am doing either, so be careful before using these! Here are the most basic commands from my collection:

INSERT: login, mysql, use db,

insert into Table (Field1,Field2,Field3,Field4) values ('NEW TEXT HERE','NEW TEXT HERE','NEW TEXT HERE','NEW TEXT HERE');

MODIFY: login, mysql, use db,

update Table set Field='NEW TEXT HERE'
where Field='TEXT HERE' and Field='NEW TEXT HERE';

DELETE: login, mysql, use db,

delete from Table where Field='TEXT HERE';

COPY: login, mysql, use db,

insert into Table select * from Table2 where Field like 'A%';

These are commands for PuTTY, but you should get the idea. If you have phpMyAdmin, use it! It makes things muuuch easier! 🙂 I have the books php & mysql for dummies and sql for dummies; they are veeery helpful! 🙂