mysql使用01
来源:互联网 发布:unity3d插件下载 编辑:程序博客网 时间:2024/06/15 01:57
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)
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的一些简单的示例,现在贴到网上。
有些东西自己学习的也不是很深入,有待以后研究。
0 0
- mysql使用01
- mysql使用
- mysql使用
- mysql 使用
- mysql使用
- mysql使用
- mysql使用
- mysql使用
- MYSQL使用
- MySql使用
- mysql使用
- mysql使用
- mysql 使用
- mysql使用
- MySQL使用
- MySQL使用
- mysql使用
- mysql使用
- Apple移动设备处理器指令集 armv6、armv7、armv7s及arm64
- 【Java.ThirdParty】日志——Log4j——2——实现剖析
- Spark1.1.0 Quick Start (link)
- 二叉树的图形显示
- html5 canvas 详细使用教程
- mysql使用01
- Spark1.1.0 Spark Programming Guide
- Balanced Binary Tree
- springMVC 读取图片(记录)
- Apple移动设备处理器指令集 armv6、armv7、armv7s及arm64
- Spark1.1.0 Spark Streaming Programming Guide
- Fedora 删除旧内核
- mysql使用02
- maven环境适配