adm88
New Member
Posts: 10
|
Post by adm88 on Oct 5, 2012 18:39:32 GMT -5
What would you like in the txt file for MySQL monitor? Should we simply write the sql CREATE statements in it, or should we copy SHOW CREATE TABLE from the cmd window? Or something else?
|
|
|
Post by Bob P on Oct 5, 2012 22:28:28 GMT -5
After you create the tables with the appropriate fields run typescript, then run the Show Tables command and then run describe <tablename> on each table. Save and exit typescript and post that text file. It will show your tables and for each table it will show field names, type, null, key, default and extra BTW, here is a great one page list of most mysql commands: www.pantz.org/software/mysql/mysqlcommands.htmlif you don't know typescript, google it and learn how to use - there are many tuts. Bob
|
|