Re: [otrs] altering a table

mysql client can connect over the network as well and he can just install that if required. I recommend Database Workbench though. I use it to manage multiple remote and local Firebird, Oracle and MySQL systems and its really the cats meow letting you do everything you need to from a nice interface including table creation/changing/maintenance, sample data population on a large scale and data migration between like and different data systems. John- ----- Original Message ----- From: Thomas Wills To: "User questions and discussions about OTRS.org" Subject: Re: [otrs] altering a table Date: Wed, 1 Feb 2006 13:46:04 +0000

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) _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/