First page Back Continue Last page Image

CREATE TABLE `planets` (

-- Let us have the database provide a unique key

`planetID` INT(5) AUTO_INCREMENT,

-- The name of the object

`planetName` VARCHAR(10) NOT NULL,

-- Add one line for each field in the table

`Mass` DECIMAL(10,4),

`Diameter_km` INT(10),

`Density_kmpmc` INT(10),

`Gravity_mpss` DECIMAL(7,2),

While the field Gravity_mpss is a Numeric field in the database, running it through the CONCATenate Function turns it into a string

Gravity is a new String Field

This one is conceptually easy because just about anything can be turned into the string representation of itself

+

=

What Is An Implicit Conversion ?