Re: [otrs] altering a table

On 01/02/06, Nils Breunese (Lemonbit Internet) wrote:

Thomas Wills:

...

On 01/02/06, Koning, Rene wrote:

...

The syntax is 'ALTER TABLE customer_user ADD afdeling VARCHAR (200); ' - the problem is which tool or program do I use to add the column and where or how do I start it??

You need a MySQL client such as http://www.mysqlfront.de/ or a web-based client such as http://www.phpmyadmin.net/ which the previous poster mentioned.

What is wrong with the standard mysql commandline interface? No need to install anything.

Good point, I forgot he was running it on his own machine. mysql -u username -p (you will be prompted for the password)