I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version
to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful queries. I am using the model example from chapter 4.8.2 The Command-line Tool. I am trying to create a table in the test database example in MySQL I am logged in correctly and using the test database that is created when MySQL is installed as best as I can tell by reviewing the command line mysql status. I am issuing the command line statement at the mysql prompt: mysql test < create.sql; I get the following mysql error: ERROR 1064 You have an error in your SQL near 'mysql test < create1.sql' at line 1 Basically, I have a script named create1.sql with the following syntax: CREATE TABLE Names ( NameID int(11) NOT NULL auto_increment, FirstName varchar(30) NOT NULL default '', LastName varchar(30) NOT NULL default '', PRIMARY KEY (NameID), KEY idx_Names_LastFirst (LastName,FirstName) ) TYPE=MyISAM; INSERT INTO Names VALUES (1,'Morton','Salter'); INSERT INTO Names VALUES (2,'Jimi','Filmore'); INSERT INTO Names VALUES (3,'Eustace','Shoe'); INSERT INTO Names VALUES (4,'Archy','Roche'); INSERT INTO Names VALUES (5,'Catherine','LaGrande'); Anyone got any suggestions? Thanks In Advance Lenny R. Sorey FatDot.com [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
