create table

[jenniferG]

we have a database  in existance and want  to    create a table  which is defined

in a text file. we do not want to load data  into a table, but to ceate a table defiunbed

in a text file.

Thanks,

Jennifer

[AndyB]

Sounds simple enough. If it's a small definition, it's probably faster to create the table by 'hand coding' a query.  If it's a large definition, it might be worth writing a few lines of code to create the query.

 

So ... what's in the definition file?

[jenniferG]

I have the few lines of code writen, I just don't know how  to  read it into mysql  from th mysql prompt. a colleague of mine sdaid to do the following  fro the mysql prompt:

 

use [dbname]

mysql >  < 'filename'  and  another says:

use [dbname]

mysql>  Load 'filename'

 

where filename contains  the table definitions.

 

Thanks,

 

Jennifer