[SOLVED] How to insert these fields into an exsisting table

[DirtySnipe]

Ive searched the forum and I cannot find a solution.

 

I need to insert the following fields into an exsisting table. How do I do it?

 

The table I need to insert into is called mrbs_entry

 

 

Here are the fields.

 

`lavf` varchar(3) NOT NULL default 'No',

  `lavl` varchar(3) NOT NULL default 'No',

  `ampli` varchar(3) NOT NULL default 'No',

  `proie` varchar(3) NOT NULL default 'No',

  `aconf` varchar(3) NOT NULL default 'No',

  `vconf` varchar(3) NOT NULL default 'No',

  `presi` varchar(3) NOT NULL default 'No',

  `puli` varchar(3) NOT NULL default 'No',

[Xurion]

You could use:

 

ALTER TABLE yourtable ADD `lavf` varchar(3) NOT NULL default 'No',
  `lavl` varchar(3) NOT NULL default 'No',
  `ampli` varchar(3) NOT NULL default 'No',
  `proie` varchar(3) NOT NULL default 'No',
  `aconf` varchar(3) NOT NULL default 'No',
  `vconf` varchar(3) NOT NULL default 'No',
  `presi` varchar(3) NOT NULL default 'No',
  `puli` varchar(3) NOT NULL default 'No';