Airline tbl
From UG
(Difference between revisions)
(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;