Airline tbl

From UG

Revision as of 16:18, 22 January 2010 (edit) Alex (Talk | contribs) (Created page with 'Category: DB <pre> mysql> describe tblAirline; +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default …') ← Older edit		Current revision as of 21:22, 3 February 2010 (edit) (undo) Alex (Talk | contribs)
(17 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category: DB]]	+	[[Category:Carriers]]
		+
		+	== MySQL  ==
	<pre>		<pre>
Line 14:		Line 16:
	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>
		+
		+	==  Fields ==
		+
		+	===Id===
		+
		+	` int(10) NOT NULL auto_increment,
		+
		+	===TwoLetterCode===
		+
		+	` varchar(2) NOT NULL,
		+
		+	===Name===
		+
		+	` varchar(30) NOT NULL,
		+
		+	===NumericCode===
		+
		+	` varchar(3) NOT NULL,

---

Current revision as of 21:22, 3 February 2010

Contents 1 MySQL 2 Fields 2.1 Id 2.2 TwoLetterCode 2.3 Name 2.4 NumericCode

[edit] MySQL

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;

[edit] Fields

[edit] Id

` int(10) NOT NULL auto_increment,

[edit] TwoLetterCode

` varchar(2) NOT NULL,

[edit] Name

` varchar(30) NOT NULL,

[edit] NumericCode

` varchar(3) NOT NULL,