Currency (tbl)

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:DB <pre> mysql> describe tblCurrency; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | …')
Line 14: Line 14:
4 rows in set
4 rows in set
 +
mysql> select * from tblCurrency;
 +
+----+-------------------+--------------+--------+
 +
| Id | Name              | Abbreviation | IsMain |
 +
+----+-------------------+--------------+--------+
 +
|  1 | US Dollars        | USD          |      1 |
 +
|  3 | Euro              | EUR          |      0 |
 +
|  9 | Swiss Francs      | CHF          |      0 |
 +
| 11 | British Pound    | GBP          |      0 |
 +
| 15 | Russian Rubles    | RUB          |      0 |
 +
| 16 | Hong kong Dollars | HKD          |      0 |
 +
| 18 | Ukrainian Hrivna  | UAH          |      0 |
 +
| 20 | Australian Dollar | AUD          |      0 |
 +
| 22 | HHH              | HHH          |      0 |
 +
| 24 | New              | NEW          |      0 |
 +
| 25 | new              | nnn          |      0 |
 +
| 26 | sfagawgawg        | nn2          |      0 |
 +
| 27 | Test              | TTT          |      0 |
 +
+----+-------------------+--------------+--------+
 +
13 rows in set
</pre>
</pre>

Revision as of 21:51, 16 December 2009



mysql> describe tblCurrency;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| Id           | int(10)     | NO   | PRI | NULL    | auto_increment |
| Name         | varchar(50) | NO   |     | NULL    |                |
| Abbreviation | varchar(3)  | NO   |     | NULL    |                |
| IsMain       | tinyint(1)  | NO   |     | 0       |                |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set

mysql> select * from tblCurrency;
+----+-------------------+--------------+--------+
| Id | Name              | Abbreviation | IsMain |
+----+-------------------+--------------+--------+
|  1 | US Dollars        | USD          |      1 |
|  3 | Euro              | EUR          |      0 |
|  9 | Swiss Francs      | CHF          |      0 |
| 11 | British Pound     | GBP          |      0 |
| 15 | Russian Rubles    | RUB          |      0 |
| 16 | Hong kong Dollars | HKD          |      0 |
| 18 | Ukrainian Hrivna  | UAH          |      0 |
| 20 | Australian Dollar | AUD          |      0 |
| 22 | HHH               | HHH          |      0 |
| 24 | New               | NEW          |      0 |
| 25 | new               | nnn          |      0 |
| 26 | sfagawgawg        | nn2          |      0 |
| 27 | Test              | TTT          |      0 |
+----+-------------------+--------------+--------+
13 rows in set
Personal tools