Commands

CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)

INSERT INTO tablename (column1, column2 ...) VALUES(value1, value2 ...)
INSERT INTO invoices (inv_no, inv_date, inv_custno, inv_address) VLAUES('1', '20060912' '134 Some Street')

CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)

CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)



Next article: HTML forms

Working with tables



Next article: HTML forms

Previous

The previous article tells you how to work with files.

Next

The next screen gives you a tutorial on how to use HTML forms.
This tutorial tells you how to create a from, call a PHP program using the form and how to process data entered in the form.

External Links

Summary

  • Create an array using the key values and a value for each element
  • Add to the end of a numeric array using []
  • Retrieve an element in an array using its key
  • Use count to find out how many elements are in an array