Airline tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category: DB <pre> mysql> describe tblAirline; +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default …')
Line 13: Line 13:
+---------------+-------------+------+-----+---------+----------------+
+---------------+-------------+------+-----+---------+----------------+
4 rows in set
4 rows in set
 +
 +
 +
 +
CREATE TABLE `tblAirline` (
 +
  `Id` int(10) NOT NULL auto_increment,
 +
  `TwoLetterCode` varchar(2) NOT NULL,
 +
  `Name` varchar(30) NOT NULL,
 +
  `NumericCode` varchar(3) NOT NULL,
 +
  PRIMARY KEY  (`Id`)
 +
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;
 +
 +
 +
</pre>
</pre>

Revision as of 15:02, 23 January 2010



mysql> describe tblAirline;
+---------------+-------------+------+-----+---------+----------------+
| Field         | Type        | Null | Key | Default | Extra          |
+---------------+-------------+------+-----+---------+----------------+
| Id            | int(10)     | NO   | PRI | NULL    | auto_increment |
| TwoLetterCode | varchar(2)  | NO   |     | NULL    |                |
| Name          | varchar(30) | NO   |     | NULL    |                |
| NumericCode   | varchar(3)  | NO   |     | NULL    |                |
+---------------+-------------+------+-----+---------+----------------+
4 rows in set



CREATE TABLE `tblAirline` (
  `Id` int(10) NOT NULL auto_increment,
  `TwoLetterCode` varchar(2) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `NumericCode` varchar(3) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;




Personal tools