擅长:python、mysql、java
<pre><code>with db:
cHandler=db.cursor()
cHandler.execute("DROP TABLE IF EXISTS Writers")
cHandler.execute("DROP TABLE IF EXISTS Readers")
cHandler.execute("CREATE TABLE Writers(Id INT PRIMARY KEY AUTO_INCREMENT, name TEXT)")
cHandler.execute("CREATE TABLE Readers(Id INT PRIMARY KEY AUTO_INCREMENT, name TEXT, Writer_id INTEGER, FOREIGN KEY(Writer_id) REFERENCES Writers(Id))")
</code></pre>