啟動mysql
MacBook-Air:~ huangyong$ brew services start mysql
登陸mysql
mysql -uroot
查看數(shù)據(jù)庫
mysql> show databases;
創(chuàng)建數(shù)據(jù)庫huang
mysql> create database huang;
使用huang
mysql> use huang;
查看表
mysql> show tables;
Empty set (0.00 sec)
創(chuàng)建表stu
mysql> create table stu(id int,
-> name varchar(20),
-> sex char(1),
-> age int);
查看表stu
mysql> show tables;
+-----------------+
| Tables_in_huang |
+-----------------+
| stu? ? ? ? ? ? |
+-----------------+
1 row in set (0.00 sec)
查看表結(jié)構(gòu)
mysql> desc stu;
+-------+-------------+------+-----+---------+-------+
| Field | Type? ? ? ? | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id? ? | int(11)? ? | YES? |? ? | NULL? ? |? ? ? |
| name? | varchar(20) | YES? |? ? | NULL? ? |? ? ? |
| sex? | char(1)? ? | YES? |? ? | NULL? ? |? ? ? |
| age? | int(11)? ? | YES? |? ? | NULL? ? |? ? ? |
+-------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
插入數(shù)據(jù)
注意：數(shù)值是在后面的，而不是我潛意識里記得的mysql> insert into stu(123,'zhao','m',20);
mysql> insert into stu (id,name,sex,age) values (123,'zhao','m',20);
Query OK, 1 row affected (0.00 sec)
在python中的操作
import MySQLdb
這次import沒任何警告提示了
連接
>>> db = MySQLdb.connect('localhost','root','','huang')
操作游標(biāo)
>>> cursor = db.cursor()
要執(zhí)行語句
>>> sql = '''insert into stu (id,name,sex,age) values (125,'li','w',23) '''
執(zhí)行
>>> cursor.execute(sql)
提交
>>> db.commit()
關(guān)閉
>>> db.close()
循環(huán)
>>> sql = '''insert into stu (id,name,sex,age) values (125,'li','w',23) '''
>>> cursor.execute(sql)
可以插入多條，
最后>>> db.commit()一下
