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