You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<p>For this tutorial, we'll use the <ahref="http://www.sqlalchemy.org/">sqlalchemy</a> Python library to communicate with a database.</p>
63
+
<h1id="Create-A-Database">Create A Database<aclass="anchor-link" href="#Create-A-Database">¶</a></h1><p>For this tutorial, we'll use the <ahref="http://www.sqlalchemy.org/">sqlalchemy</a> Python library to communicate with a database.</p>
72
64
<p>Let's import it:</p>
73
65
74
66
</div>
@@ -156,7 +148,7 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
<p>Before we can add any data to our database, we'll need to create a table in which to hold it.</p>
63
+
<h1id="Create-a-Table">Create a Table<aclass="anchor-link" href="#Create-a-Table">¶</a></h1><p>Before we can add any data to our database, we'll need to create a table in which to hold it.</p>
<p>Now that we have a table, it's time to add some data into it.</p>
63
+
<h1id="Add-Some-Data">Add Some Data<aclass="anchor-link" href="#Add-Some-Data">¶</a></h1><p>Now that we have a table, it's time to add some data into it.</p>
<p>So far, we have created a table and inserted three records into it.</p>
63
+
<h1id="Look-At-The-Data">Look At The Data<aclass="anchor-link" href="#Look-At-The-Data">¶</a></h1><p>So far, we have created a table and inserted three records into it.</p>
72
64
<p>To see the results, we've had to install a separate piece of software. It would be much nicer to use Python to show us the content of our database.</p>
<p>To change records in a table, we use an 'UPDATE' statement.</p>
63
+
<h1id="Change-The-Data">Change The Data<aclass="anchor-link" href="#Change-The-Data">¶</a></h1><p>To change records in a table, we use an 'UPDATE' statement.</p>
72
64
<p>First, let's connect to our database and remind ourselves what records we have created so far:</p>
<p>We have created a table, inserted three records into it and made changes to one of those records.</p>
63
+
<h1id="Delete-Some-Data">Delete Some Data<aclass="anchor-link" href="#Delete-Some-Data">¶</a></h1><p>We have created a table, inserted three records into it and made changes to one of those records.</p>
72
64
<p>What if we want to delete a record completely?</p>
73
65
<p>Lets's connect to our database and remind ourselves of its content:</p>
0 commit comments