Skip to content
Snippets Groups Projects
Select Git revision
  • 0d63c279a28d9393532d8a2db0fa7dd8290ca7bd
  • main default protected
2 results

databaseCrypto.sh

Blame
    • databaseCrypto.sh 437 B
    1
    2
    3
    4
    5
    6
    7 
    

    

    

    #! /usr/bin/bash

$(/opt/lampp/bin/mysql -u root -e "create database cryptoTracker; use cryptoTracker")
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; create table crypto (id int, name varchar(20))")
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; create table cryptoPrice (id int PRIMARY KEY, value float,collected datetime)")
$(/opt/lampp/bin/mysql -u root -e "use cryptoTracker; insert into crypto values (1,'Bitcoin')")