Step 5: A Quick Method of mySQL Table Creation

This is Step 5 of an installation and configuration tutorial for mySQL 4.1 and dBASE Plus on a Windows 2000 Professional machine. Click here for the index.

1. In the previous step, we created a table in our mySQL database using the dBASE Table Creation Wizard. It was slow and easy. We can achieve the same results using an SQL statement.
2. Highlight and copy (ctrl-c) this statement:
   
   CREATE TABLE 'billing' ( 'Billing number' varchar(5) default NULL, 'Customer ID' varchar(5) default NULL, 'Employee ID' varchar(5) default NULL, 'Amount' double default NULL, 'Rate' double default NULL, 'Billing hours' double default NULL, 'Billing date' varchar(10) default NULL, 'Notes` longtext, UNIQUE KEY 'billingID' ('Billing number') ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
   
   
3. Open dBASE Plus and paste (ctrl-v) the command into the Command Window. Press Enter to execute the statement. Doesn't work, does it?
4. We will now try to track down the problems...
5. sdf
6. Good luck and let me know if you find any errors in this tutorial. Thank you!

Prev: Step 4: Connecting dBASE to mySQL using the BDE
Next: Step 6: Making configuration changes in mySQL

The MySQL Logo is a registered trademark of MySQL AB in the United States, the European Union and other countries.

Problems? Comments? Please contact us.
© ChelseaData.ca