-
Notifications
You must be signed in to change notification settings - Fork 0
/
creating tables.sql
50 lines (40 loc) · 1.17 KB
/
creating tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
CREATE TABLE USDLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
TaxUSD float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE GBPLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE EURLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE TNDLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE TRYLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE CNYLYD (
ID INT PRIMARY KEY auto_increment,
Price_Date DATE,
Buy float(5,4),
Sell float(5,4),
creation_time DATETIME DEFAULT CURRENT_TIMESTAMP);
#insert into USDLYD (Price_Date,Sell,Buy,TaxedSell) values ('2020-11-17',1.4342,1.3456,3.4565);
#select * from USDLYD;
#drop table USDLYD;