I have a MySql database table, where I need to add the following fields, Please tell me how can I do it with PhpMyadmin? `DetailedDesc` text NOT NULL, `Price` float(15,2) NOT NULL default '0.00', `image` text NOT NULL,
view the structure of the table. Below that is an "add field" dialog. It's pretty easy in phpmyadmin.
Thanks, I know that but what I want to know is if there is a SQL command I can run to automatically create these field?
phantomddl is right the 'ALTER TABLE' command should work, something like: ALTER TABLE customers ADD COLUMN address VARCHAR(30);
use alter table command to add fields Alter table <table name> add (field name, type.....); thats all