title: Inserting into MySQL from Python - Errors
body: <p>I am trying to write a record into a MySQL DB where I have defined table <code>jobs</code> as:</p>
  
  <pre><code>CREATE TABLE jobs(
     job_id INT NOT NULL AUTO_INCREMENT,
     job_title VARCHAR(300) NOT NULL,
     job_url VARCHAR(400) NOT NULL,
     job_location VARCHAR(150),
     job_salary_low DECIMAL(25) DEFAULT(0),
     job_salary_high DECIMAL(25), DEFAULT(0),
     company VARCHAR(150),
     job_posted DATE,
     PRIMARY KEY ( job_id )
  );
  </code></pre>
  
  <p>The code I am testing with is:</p>
  
  <pre><code>cur.execute("INSERT INTO jobs VALUES(DEFAULT, '"+jobTitle+"','"
      +jobHref+"',"+salaryLow+","+salaryHigh+",'"+company+"',"
      +jobPostedAdjusted+"','"+salaryCurrency+"';")
  print(cur.fetchall())
  </code></pre>
  
  <p>The errors that I am getting are:</p>
  
  <pre><code>pydev debugger: starting
  Traceback (most recent call last):
    File "C:\Users\Me\AppData\Local\Aptana Studio 3\plugins\org.python.pydev_2.7.0.2013032300\pysrc\pydevd.py", line 1397, in &lt;module&gt;
      debugger.run(setup['file'], None, None)
    File "C:\Users\Me\AppData\Local\Aptana Studio 3\plugins\org.python.pydev_2.7.0.2013032300\pysrc\pydevd.py", line 1090, in run
      pydev_imports.execfile(file, globals, locals) #execute the script
    File "C:\Users\Me\Documents\Aptana Studio 3 Workspace\PythonScripts\PythonScripts\testFind.py", line 25, in &lt;module&gt;
      +jobPostedAdjusted+"','"+salaryCurrency+"';")
  TypeError: cannot concatenate 'str' and 'float' objects
  </code></pre>
  
  <p>What is the best way insert this record? Thanks.</p>