To create a console application in python using sqlite database

condition if-else statement is not working properly...let me known,find mine mistake as soon as possible.if i am using def statement if else condition should not not execute. Here is the code I used to do that:

    import sqlite3
    print("Welcome to console application")
    conn=sqlite3.connect(r"D:\brill.db")
    s=conn.cursor()
    print("program to create,insert,update,delete\n\n")
    regno=input("what is your reg number:")
    name = input("What's your name? ")
    age = input("Your age? ")     
    Domain=input("what is your domain")
    email =input("enter your email")
    ph_no=input("what is your phone number")    
    print("Enter the operation to be performed\n 1.create\n 2.update\n 3.delete\n 4.exit")
    c=int(input())
    if(c==1):
        print(regno,name,age,Domain,email,ph_no)    
    elif(c==2):
        print(regno,name,age,Domain,email,ph_no)
        regno=int(input("what is your reg number:"))
        if regno==regno:
            s.execute('''UPDATE user SET  name='tamil',age='21',Domain='php',email='',ph_no='9500783334' WHERE regno=regno''') 
            print("sucessfully")
        else:
            print ("there is invalid register number")  
    elif(c==3):
        regno=input("enter your reg number")
        print (regno)
    else:
        print("close")
    #s.execute('''CREATE TABLE user(regno number,name varchar,age int,domain varchar,email varchar,ph_no int)''')
    if(c==1):
        s.execute('''INSERT INTO user (regno,name,age,Domain,email,ph_no) values(?,?,?,?,?,?)''', (regno,name,age,Domain,email,ph_no))
        print("inserted successfully")
    elif(c==2):
        #s.execute('''UPDATE user SET regno=?, age=?,domain=?,email=?,ph_no=? WHERE name= ""''', (regno,age,Domain,email,ph_no))
        print("updated successfully")
    elif(c==3):
        s.execute('DELETE FROM user WHERE regno = ? ',[regno])
        print("deleted successfully")
    conn.commit()
    conn.close()