title: How to use user input to create databases
body: <p>How do I get input from user to create databases in python? These data must stored in test.db file.</p>
  
  <p><strong>Code</strong></p>
  
  <pre><code>import sqlite3
  
  conn = sqlite3.connect('test.db');
  print "Opened database successfully";
  
  
  name=raw_input ("enter your name: ");
  salary=raw_input("enter your salary: ");
  
  conn.execute("INSERT INTO employee (NAME,SALARY) \
        VALUES ( r"+name+",r "+salary+")");
  
  conn.commit()
  </code></pre>