mysql数据库操作

cmd进python

	mysql -u用户名 -p密码

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mypy               |
| mysql              |
| performance_schema |
| pythondb           |
| sakila             |
| student            |
| sys                |
| world              |
+--------------------+
9 rows in set (0.15 sec)

mysql> use mypy
Database changed
mysql> show tables;
+----------------+
| Tables_in_mypy |
+----------------+
| student        |
+----------------+
1 row in set (0.06 sec)

mysql> select *from student;
+------+-------------+------+
| Name | Email       | Age  |
+------+-------------+------+
| Mike | 123@163.com |   20 |
+------+-------------+------+
1 row in set (0.05 sec)

mysql> describe pet;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name  | varchar(20) | YES  |     | NULL    |       |
| owner | varchar(20) | YES  |     | NULL    |       |
| sex   | char(1)     | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> create table information(
    -> qq int,
    -> stuNumber int
    -> );
Query OK, 0 rows affected (0.12 sec)

#创建游标
cur=conn.cursor()
#查询info表的所需字段数据
cur.execute('select qq,stuNumber from info')
#获取info所有数据
result = cur.fetchall()
print(result);