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
));
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
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
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