RE: Adding a Column to an existing table

2002-03-26 Thread Steven Gearhart
The easiest way to add a column is to get somebody else to do it. Seriously, Use the ALTER TABLE TableName ADD COLUMN Company_id INT UNSIGNED NULL command. This syntax may be found in the MySQL manual in 6.5.4 http://www.mysql.com/doc/A/L/ALTER_TABLE.html ,or page 428 if you have downloaded the

MySQL oddity

2002-03-22 Thread Steven Gearhart
)); CREATE UNIQUE INDEX CHARLIMITS_PK ON CHAR_LIMITS( CHAR_ID); /*/ Steven Gearhart Gearhart, Inc. Phone/Fax: 770.466.2898 Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

RE: GRANT

2002-03-21 Thread Steven Gearhart
If I understand correctly, you can achieve your goal in either of 2 ways. The first, is to copy sql.exe to one of your path directories (i.e. Windows or Windows\System) or include MySQL\bin in your DOS path statement. This will allow you to run mysql from a DOS prompt. The second method is to

Can not run multiple command scripts

2002-03-16 Thread Steven Gearhart
GUI interfaces with the same result. I am able to run a single command, however, if I try and run a script with two or more commands, I receive an error number 1064 - syntax error. This usually shows the error at line 1. What am I doing wrong? I am about to give up. /*/ Steven