Learning SQL commands

I found a youtube video that shows how to install MySQL in linux, and now I am creating databases and tables using SQL.  The picture shows the  commands to get My SQL started.

Some sqlite and python

import sqlite3
from Tkinter import *

def addData():
    conn=sqlite3.connect('deedinfo.db')
    cur=conn.cursor()
    cur.execute("create table if not exists deedtrack(bkpage text,grantor text,grantee text,action text)")

    #Get data from user
    bookpage=raw_input("Book & Page? ")
    seller=raw_input("Grantor? ")
    buyer=raw_input("Grantee?")
    action=raw_input("Do what? ")

    #Inserts data into table
    cur.execute("insert into deedtrack values (?,?,?,?)",(bookpage,seller,buyer,action))

    conn.commit() #Saves the data
   
    myrows=cur.execute("select * from deedtrack")

    for row in myrows:
        print("---------------------------")
        print row[0]
        print row[1]
        print row[2]
        print row[3]
       
def listData():
    conn=sqlite3.connect('deedinfo.db')
    cur=conn.cursor()

    myrows=cur.execute("select * from deedtrack")

    for row in myrows:
        print("---------------------------")
        print row[0]
        print row[1]
        print row[2]
        print row[3]

root=Tk()
btn=Button(root,text="List table",command=listData)
btn.pack()
btn2=Button(root,text="Add to table",command=addData)
btn2.pack()
root.mainloop()

I updated my deed tracker program

from Tkinter import *
import webbrowser

def openWebDox():
    webbrowser.open('http://snintraweb/rod/gis.aspx')
  
def ListFile():
    result_f=open('Deedinfo.txt')
    for eachline in result_f:
        print eachline
    result_f.close()
  

def DataSave():
    fob=open('Deedinfo.txt','a')
    fob.write('---------------------------------------------------------\n')
    fob.write('Book Page: '+ deed.get()+'\n')
    fob.write('Deed date\: '+ deeddate.get()+'\n')
    fob.write('GRANTOR: ' + grantor.get()+'\nGRANTEE: ' + grantee.get()+'\n')
    #fob.write('Grantee: ' + grantee.get()+'\n')
    fob.write('PIN :'+pin.get()+'\n')
    fob.write('Action taken: '+ theAction.get()+'\n')
    fob.close
    #clears entry boxes inside of root
    deed.delete(0,END)
    deeddate.delete(0,END)
    grantor.delete(0,END)
    grantee.delete(0,END)
    pin.delete(0,END)

def newwin():  #Opens a new window with a text widget. cool!
    top= Toplevel(root)
  
    textwin=Text(top)
    textwin.pack()
    f=open("Deedinfo.txt")
    for eachline in f:
        textwin.insert(END, eachline)
    f.close()

  
    top.mainloop()

    aline.close()

root = Tk()
#root.geometry('200x450')
root.config(bg='limegreen')

Label(text = 'Book & Page').pack()
deed = Entry(root)
deed.pack(padx=5,pady=5)

Label(text='Deed Date').pack()
deeddate=Entry(root)
deeddate.pack(padx=5,pady=5)

Label(text='Grantor ').pack()
grantor =Entry(root)
grantor.pack(padx=5,pady=5)

Label(text='Grantee').pack()
grantee=Entry(root)
grantee.pack(padx=5,pady=5)

Label(text='Parcel ID').pack()
pin=Entry(root)
pin.pack(padx=5,pady=5)

#Radio button widgets
theAction=StringVar()
theAction.set(None)
Radiobutton(root,text='Map work card',value='Map work card',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Split',value='Split',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Combination',value='Combination',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Split/Combo',value='Split/Combo',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Not in title',value='Not in title',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Name change',value='Name change',bg='limegreen',variable=theAction).pack()

saveBtn=Button(root,text='Save ', command=DataSave)
saveBtn.pack(padx=2,pady=2)

win1Btn=Button(root,text='New win',command=newwin)
win1Btn.pack()

listBtn=Button(root,text='List Deed File',command=ListFile)
listBtn.pack(padx=2,pady=2)

WebDoxBtn=Button(root,text='Web Dox',command=openWebDox)
WebDoxBtn.pack(padx=2,pady=2)
root.mainloop()

Some more C

#include
#include

int main()
{
char name[100];
printf("What is your name?");
fgets(name,100,stdin);

printf("your name is %s", name);
}

Installed a new Operating Sysytem

I downloaded Trisquel, and then burned it to a CD using xburn. Worked very well. Then I used the ISO disk to install it on my laptop.