mysql使用01

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> create table account(
    -> id int unsigned,
    -> balance int )engine=innodb default charset=utf8;
Query OK, 0 rows affected (0.09 sec)

mysql> insert into account values(1,2300),(2,2400),(3,1200),(4,2300);
Query OK, 4 rows affected (0.03 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from account;
+------+---------+
| id   | balance |
+------+---------+
|    1 |    2300 |
|    2 |    2400 |
|    3 |    1200 |
|    4 |    2300 |
+------+---------+
4 rows in set (0.00 sec)

mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)

mysql> update account set balance=balance-200 where id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update account set balance=balance+200 where id=2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.04 sec)

mysql> select * from account;
+------+---------+
| id   | balance |
+------+---------+
|    1 |    2100 |
|    2 |    2600 |
|    3 |    1200 |
|    4 |    2300 |
+------+---------+
4 rows in set (0.00 sec)

mysql> exit

这是原来自己学习sql的一些简单的示例，现在贴到网上。

有些东西自己学习的也不是很深入，有待以后研究。