Create Table With SQL File

[yabba321]

Hi All

I'm fairly new to MySQL devlopment, and Im trying to create a table in and existing MySQL database using an sql file on windows platform

Contents of insert.sql

CREATE TABLE `contact_details` (
`User_ID` int(10) unsigned NOT NULL auto_increment Primary Key,
`f_name` varchar(20) default NULL,
`l_name` varchar(20) default NULL,
`address1` varchar(45) default NULL,
`postcode` varchar(7) default NULL,
`email` varchar(60) default NULL
);

I copy this file into c:\program files\MySQL\MySQL Server 5.0\bin

and try to create the tabel using the following command at the dos prompt
the database is called test it does exist and its empty

c:\program files\MySQL\MySQL Server 5.0\bin> mysql test < insert.sql
but all this does is list a whole load of help info and does not create anything

[Speeple]

Have you tried:

mysql source insert.sql

[yabba321]

Thanks I tried the command

c:\program files\MySQL\MySQL Server 5.0\bin> mysql test source insert.sql
and the same thing happens. Something seem to be fundamentally wrong. Just list a load of help/configuration info

Thanks anyway.

[kleineme]

c:\program files\MySQL\MySQL Server 5.0\bin> mysql -D test -u root -p < insert.sql

change root to a user of your choice

[yabba321]

Thank you very much kleineme that works perfectly, I owe you one

[guelphdad]

note you can also run the program after you have logged into mysql simply by using

SOURCE filename

and the other thing, you can store the files anywhere you want whether you call them directly in mysql or from the shell as kleineme pointed out above. you then just use the full path to the file

i.e.

SOURCE c:/somedirectory/subdirectory/filename