"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/tables.rst" (6 May 2012, 723 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

Tables

A table makes up a collection of /columntypes that can be joined together in order to create relational result sets.

Each record in the table is called a row, and a table can have an infinite set of rows. Each row represents one piece of data, and each column can be thought of as representing a component of that piece of data.

So, for example, if we have a table for a customer information, then the columns may include information such as First Name, Last Name, Address, City, Country, Birth Date, and so on. As a result, tables have column headers, which specify the data types for that particular column.

alter_table create_table drop_table truncate rename