Creating a database table with Mini SQL (mSQL) is very simple. All you have to do is use the msql command.
Let's assume that you want to create a new database table named Customer in the database named contact_mgr. At the Unix command line, type:
In the msql utility, create the table in mSQL with the usual SQL syntax. Then type \g (mSQL's go command), and then type \q when you're ready to quit. The sequence of commands in the msql utility looks like this:
create table Customer
last_name char(20) )
At this point you'll be returned to the Unix command line.
This command created a database table named Customer
in the database named contact_mgr. The Customer table
contains three fields named cnum, first_name,
Other locations on the Developer's Daily web site
We invite you to visit other free educational resources on our web site: