python数据表_Python操作MariaDB创建数据表及增删改查

查询数据操作前，先插入几条数据，完整代码如下：

>>> insertsql = 'insert into testtable(id,name,gender) values (1,"user1","M")'

>>> cursor.execute(insertsql)

1L

>>> insertsql = 'insert into testtable(id,name,gender) values (2,"user2","M")'

>>> cursor.execute(insertsql)

1L

>>> insertsql = 'insert into testtable(id,name,gender) values (3,"user3","M")'

>>> cursor.execute(insertsql)

1L

>>> conn.commit()

>>> selsql = 'select * from testtable'

>>> cursor.execute(selsql)

3L

>>> result = cursor.fetchone()

>>> print (result)

('user1', 1L, 'M')

插入了三条数据，fetchone只取查询结果的一条，返回一个列表格式的数据。