sqlalchemy简单操作(创建表，反射表)

1. 标准创建表语句

CREATE TABLE `person`(
	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`name` VARCHAR(20) NOT NULL,
	`age` INT NOT NULL DEFAULT 20,
	`sex` SMALLINT DEFAULT 1,
	`t_time` DATETIME NULL
) DEFAULT CHARSET='utf8';

2.标准插入数据语句

INSERT INTO `person` (`name`,`age`,`sex`,`t_time`) VALUES ("king",30,1,now());

插入多条

INSERT INTO `person` (`name`,`age`,`sex`,`t_time`) VALUES 
("rose",40,1,now()),
("jack",50,1,now()),
("mary",60,1,now());

3.标准修改数据语句

UPDATE `person` SET `name`="SB" WHERE `name`="jack";
 或者
 UPDATE `person` SET `name`="SB" WHERE `id`=2;
 ...

4.标准删除数据语句

DELETE FROM `person` WHERE `id`=1;
...

5.标准查询数据语句

SELECT `person`.`name`, `person`.`age` FROM `person`
WHERE `age`<=50 
GROUP BY ...
ORDER BY `age` DESC 
LIMIT 0,3;
...

6.使用MySQLdb做增删改查↓

# -*- coding: utf-8 -*-
# @Author: Lai

import MySQLdb
from datetime import datetime


class MySQLHelper(object):
    def __init__(self):
        self.get_connect()

    # 打开连接
    def get_connect(self):
        try:
            self.conn = MySQLdb.connect(
                user="root",
                passwd="123456",
                db="todo",
                port=3306,
                host="127.0.0.1",
                charset="utf8",
            )
        except MySQLdb.Error as e:
            print(e)

    # 关闭连接
    def get_closed(self):<