Can not run multiple command scripts

2002-03-16 Thread Steven Gearhart
used the command line and several 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. /

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

MySQL oddity

2002-03-22 Thread Steven Gearhart
PRIMARY KEY (CHAR_ID)); CREATE UNIQUE INDEX CHARLIMITS_PK ON CHAR_LIMITS( CHAR_ID); /*/ Steven Gearhart Gearhart, Inc. Phone/Fax: 770.466.2898 Email: [EMAIL PROTECTED] - Before posti

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