Fedora web server
Here are the structure and sample values for those tables: CREATE TABLE `event` ( `code` int(11) NOT NULL, `description` char(40) NOT NULL, PRIMARY KEY (’code’) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `event` VALUES (1, ‘washed’); The usage of backticks here (’event’), although not standard SQL, is a MySQL extension used to enclose and protect identifiers. In this specific case, it could help us with MySQL 5.1 in which the event keyword is scheduled to become part of the language for some another purpose (CREATE EVENT). At the time of writing, beta version MySQL 5.1.11 accepts CREATE TABLE event, but it might not always be true. The following image shows sample values entered into the event table from within the Insert sub-page of phpMyAdmin: CREATE TABLE `car_event` ( `internal_number` int(11) NOT NULL, `moment` datetime NOT NULL, `event_code` int(11) NOT NULL, PRIMARY KEY (’internal_number’) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `car_event` VALUES (412, ‘2006-05-20 09:58:38′, 1);
Note: In case you are looking for affordable and reliable webhost to host and run your business application check Vision business hosting services