Skip to content
Snippets Groups Projects
Select Git revision
  • 00287095338db6ef618ded5edd1434e3f3f8313d
  • main default protected
2 results

databaseCryptoUpdated.sh

Blame
    • databaseCryptoUpdated.sh 765 B
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23 
    

    

    

    #! /usr/bin/bash

$(/opt/lampp/bin/mysql -u root -e "create database cryptoTracker; use cryptoTracker")

#To store different types of crypto
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; create table crypto (cryptoId int PRIMARY KEY, name varchar(20))")
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; insert into crypto values (1,'Bitcoin')")


#To store the crypto price (value)
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; 
create table cryptoPrice (
id int AUTO_INCREMENT,
cryptoID int,
value float,
collected datetime,
PRIMARY KEY(id),
FOREIGN KEY(cryptoID) REFERENCES crypto(cryptoId)
)")

$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; 
insert into cryptoPrice(cryptoID,value,collected) values (1,29.93,'2022-03-03 12:00:00')")