show databases;--显示当前数据库createdatabase mybuaa;--新建数据库
use mybuaa; --使用数据库--创建数据表droptableifexists entries;createtable entries (
id integerprimarykey auto_increment,
amount integernotnull,
description text notnull,
money integernotnull,
people text notnull,
exedate datenotnull
);insertinto entries values(1,-255,'水费',-140,'孟德超',CURDATE());--增deletefrom entries where id = 1;--删update entries set people = "孟德超"where id = 1;--改select people,exedate from entries where id = 1;--查droptable entries;--删除表单drop mybuaa;--删除数据库
进入mysql mysql -u root -p更改默认编码方式为UTF-8 http://blog.csdn.net/red4711/article/details/6007248备份和还原 http://blog.csdn.net/quietprofound/article/details/2947197常见指令show databases; --显示当前数据库create da