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做增删改查↓
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):<