Language Guide

Creating SQL Tables

If you're an SQL user, chances are that you already have a number of database files available, and that some or all of them will be used in developing your heitml Web Pages. Nevertheless, there may be times when you wish to create new SQL tables from within your heitml application, and the following code samples provide a simple demonstration of how that can be accomplished using the <dbupdate> command.

For Standard SQL:	Some SQL's allow this:
<dbupdate> CREATE TABLE tablename (Guest_Name char(50), Email char(50), Address char(60), Country char(60), Comment char(250), Password char(8)) </dbupdate>	<dbupdate> CREATE TABLE tablename (Guest_Name varchar(50), Email varchar(50), Address varchar(60), Country varchar(60), Comment varchar(250), Password varchar(8)) </dbupdate>

Note: It is beyond the scope of this text to discuss the differences between various implementations of SQL. If you are only using one SQL database program, you probably don't care about the differences. And if you're using more than one, chances are you've already discovered these differences for yourself. Many vendors add their own extensions to a given software standard, either as a means of filling what they perceive to be gaps in their functionality, or simply as a means of differentiating their product from that of another vendor. This Language Guide will strive as much as possible to adhere to the SQL standard and provide single code examples that work under all SQL implementations. When necessary or desireable, however, we will provide multiple examples, leaving it to the Reader to ponder the reasons why.