PERL操作程序五十九(mscmoney.pl,外汇汇率输入程序和界面)
返回
- money_usd2jpy
- money_eur2jpy
- money_gbp2jpy
- money_rmb2jpy
- money_sgd2jpy
money_usd2jpy.sql
----------------------------------
DROP TABLE IF EXISTS money_usd2jpy;
CREATE TABLE money_usd2jpy
(
id INT AUTO_INCREMENT,
t TIMESTAMP,
usd2jpy varchar(100),
PRIMARY KEY (id)
);
INSERT INTO money_usd2jpy (usd2jpy) VALUES("90");
C:\database\sql>mysql -u cbuser -p cookbook < money_usd2jpy.sql
Enter password: ******
mysql> select * from money_usd2jpy;
+----+---------------------+---------+
| id | t | usd2jpy |
+----+---------------------+---------+
| 1 | 2012-01-13 23:20:43 | 90 |
+----+---------------------+---------+
1 row in set (0.02 sec)
返回