affected - 腾讯云开发者社区

1.1K8 0

【MySQL】数据库的操作(上)

1490 0

您找到你想要的搜索结果了吗？

是的

没有找到

MySQL二进制日志截取和恢复

1.3K0 1

MySQL备份恢复

13K2 1

MySQL 事务的隔离级别及锁操作演示

二、数据库服务设置 1、事务隔离级别设置 mysql> set global transaction_isolation = 'repeatable-read'; Query OK, 0 rows affected...-------------------------+ 2、锁等待时间设置 mysql> set global innodb_lock_wait_timeout=5; Query OK, 0 rows affected...设置事务隔离级别： mysql> set global transaction_isolation = 'read-committed'; Query OK, 0 rows affected (0.00...(0.00 sec) mysql> update tt set name = 'ssr' where id = 2; Query OK, 1 row affected (0.01 sec) Rows...(0.00 sec) mysql> update tt set name = 'ssrr' where id = 2; Query OK, 1 row affected (0.00 sec) Rows

6564 0

AWS 又瘫痪了。。。本月第三次了。。。：数据中心断电了。。。

within the affected Availability Zone....If you are able to relaunch affected EC2 instances within the affected Availability Zone, that may help...If you are able to relaunch affected EC2 instances within the affected Availability Zone, that may help...path to recovery now would be to relaunch affected EC2 instances within the affected Availability Zone...If you have the ability to relaunch an affected EC2 instance or recreate an affected EBS volume from

6171 0

数据库MySQL-数据类型

stu1( -> id tinyint, # 范围要尽可能小，范围越小，占用空间越少 -> name varchar(20) -> ); Query OK, 0 rows affected...(0.05 sec) mysql> insert into stu4 values (12,12); Query OK, 1 row affected (0.00 sec) mysql> select...(0.05 sec) mysql> insert into stu5 values (3.1415,12.96); Query OK, 1 row affected (0.00 sec) mysql...(0.03 sec) mysql> insert into stu6 values (5E2),(6E-2); # 插入科学计数法 Query OK, 2 rows affected (0.00 sec...(0.00 sec) mysql> insert into stu8 values(12.999999999); Query OK, 1 row affected (0.00 sec) mysql

2K2 0

故障分析 | 报错 ERROR 5270 -HY000-- object not in RECYCLE BIN 引发的几个思考

报错复现： MySQL [mysql]> create table test.a (i int) ; Query OK, 0 rows affected (0.04 sec) MySQL [mysql]...> set session recyclebin = 1 ; Query OK, 0 rows affected (0.00 sec) MySQL [mysql]> drop table test.a...; Query OK, 0 rows affected (0.01 sec) MySQL [mysql]> show recyclebin ; +----------------------------...MySQL [oceanbase]> create table test.a(i int) ; -- 在test库中创建表a Query OK, 0 rows affected (0.05 sec...) MySQL [oceanbase]> set session recyclebin=1 ; -- 开启回收站 Query OK, 0 rows affected (0.00 sec)

3192 0

技术分享 | 七个实验掌握 MySQL 8.0 角色功能

(0.02 sec) mysql> grant all on ytt_new.* to db_owner; Query OK, 0 rows affected (0.01 sec) mysql...,delete,update on ytt_new.* to db_datawriter; Query OK, 0 rows affected (0.01 sec) 创建三个普通用户，分别为 ytt1...default role db_owner to ytt1; Query OK, 0 rows affected (0.00 sec) mysql> grant db_datareader...OK, 0 rows affected (0.01 sec) mysql> grant db_datawriter to ytt3; Query OK, 0 rows affected (0.01...mysql> grant db_owner,db_datareader,db_datawriter to ytt4; Query OK, 0 rows affected (0.01 sec)

5262 0

mysql-完整性约束

- 可空默认值，创建列时可以指定默认值，当插入数据时如果未主动设置，则自动添加默认值 mysql> create database db1; # 创建db1数据库 Query OK, 1 row affected...mysql> create table tb1(id int not null default 2,num int not null); # 创建tb1表并约束 Query OK, 0 rows affected...(0.03 sec) mysql> insert into department values(1,'IT'),(2,'IT'); Query OK, 2 rows affected (0.01 sec...(0.01 sec) mysql> insert into student values(7,'web','female'); Query OK, 1 row affected (0.00 sec)...(0.02 sec) mysql> insert into student(name) values('呃呃'); Query OK, 1 row affected (0.01 sec) mysql>

8211 0

innodb_flush_log_at_trx_commit参数对插入性能的影响测试方法

NULL, -> PRIMARY KEY (`id`), -> KEY `a` (`a`) -> ) ENGINE=InnoDB; Query OK, 0 rows affected..., 3 warnings (0.22 sec) mysql> mysql> drop procedure idata; Query OK, 0 rows affected (0.07 sec) mysql...(0.01 sec) mysql> delimiter ; mysql> call idata(); Query OK, 1 row affected (8.05 sec) ----------...(0.01 sec) mysql> delimiter ; mysql> call idata(); Query OK, 1 row affected (5.76 sec) -----------...(0.01 sec) mysql> delimiter ; mysql> call idata(); Query OK, 1 row affected (3.88 sec) 可以看到：该参数设置为

8442 0

MySQL事务

(0.02 秒) mysql> update yh set money=money+500 where name='李四'; Query OK, 1 rows affected (0.04 秒)...(0.01 秒) #执行从张三帐户扣出500元 mysql> update yh set money=money-500 where name='张三'; Query OK, 1 rows affected...(0.01 秒) #执行往李四帐户加入500元 mysql> update yh set money=money+500 where name='李四'; Query OK, 1 rows affected...(0.01 秒) #提交事务 mysql> commit; Query OK, 0 rows affected (0.08 秒) #查看帐户 mysql> select * from yh; +---...(0.01 秒) #事务回滚 mysql> rollback; Query OK, 0 rows affected (0.02 秒) #查看帐户 mysql> select * from yh; +-

4.2K1 0

MySQL数据insert测试

、没索引drop table if exists t;create table t (a int, b int, c int);mysql> call idata();Query OK, 1 row affected...有主键，有唯一索引情况下：mysql> call idata();Query OK, 1 row affected (43.26 sec)8、手动commitset global sync\_binlog...(20.82 sec)mysql> commit;Query OK, 0 rows affected (0.28 sec)drop table if exists t;create table t (...(21.78 sec)mysql> commit;Query OK, 0 rows affected (0.31 sec)9、alter table t disable keys;mysql> call...idata();Query OK, 1 row affected (4 min 8.54 sec)测试小结场景idata耗时没主键、没索引2 min 58.78 sec；idata后创建索引耗时1.07

1.4K3 0

Mysql系列 - 第4天：DDL常见操作汇总

-----------+ 1 row in set (0.00 sec) mysql> drop database if exists javacode2018; Query OK, 0 rows affected...(0.02 sec) mysql> insert into test2(a) values (1); Query OK, 1 row affected (0.00 sec) mysql> select...(0.02 sec) mysql> insert into test4(a,b) values (1,1); Query OK, 1 row affected (0.00 sec) mysql>...(0.02 sec) mysql> mysql> insert into test7(a,b) VALUES (1,1); Query OK, 1 row affected (0.00 sec)...table test5( -> a int not null comment '字段a' primary key -> ); Query OK, 0 rows affected (

9872 0

Go 语言使用 XORM 操作 MySQL 的陷阱

= nil { fmt.Printf("Update err=%v\n", err) return } fmt.Printf("affected=%d\n", affected) } type...= nil { fmt.Printf("Insert err=%v\n", err) return } fmt.Printf("affected=%v\n", affected) 阅读上面这段代码...id := example.Id fmt.Printf("affected=%v || id=%d\n", affected, id) 阅读上面这段代码，我们想要获取新插入数据的自增 id，直接 example.Id...= nil { fmt.Printf("Update err=%v\n", err) return } fmt.Printf("affected=%d\n", affected) 阅读上面这段代码...= nil { fmt.Printf("RowsAffected err=%v\n", err) return } fmt.Printf("affected=%d\n", affected)

4492 0

第31期：索引设计（索引数量探讨）

操作这 10 张表时间对比： (debian-ytt1:3500)|(ytt)>call sp_batch_write('update','t1',100000); Query OK, 0 rows affected...(22.81 sec) (debian-ytt1:3500)|(ytt)>call sp_batch_write('update','t2',100000); Query OK, 0 rows affected...(47.42 sec) (debian-ytt1:3500)|(ytt)>call sp_batch_write('update','t3',100000); Query OK, 0 rows affected...(31.80 sec) (debian-ytt1:3500)|(ytt)>call sp_batch_write('delete','t2',100000); Query OK, 0 rows affected...(59.89 sec) (debian-ytt1:3500)|(ytt)>call sp_batch_write('delete','t3',100000); Query OK, 0 rows affected

2802 0

数据库MySQL-列属性

not null default '姓名不详', -> addr varchar(50) not null default '地址不详' -> ); Query OK, 0 rows affected...(0.05 sec) mysql> insert into stu19(name) values ('tom'); Query OK, 1 row affected (0.00 sec) mysql...> insert into stu19 values (default,default); Query OK, 1 row affected (0.00 sec) mysql> select * from...(0.05 sec) -- 添加主键 mysql> alter table stu23 add primary key(id); Query OK, 0 rows affected (0.09 sec...(0.05 sec) -- 插入数据 mysql> insert into stu25 values (3,'tom'); -- 可以直接插入数字 Query OK, 1 row affected

3.1K3 0

MySQL 死锁后事务无法回滚是真的吗？

(0.02 sec) mysql> insert into test_deadlock (id,name) values (1,'a'); Query OK, 1 row affected (0.01...sec) mysql> insert into test_deadlock (id,name) values (2,'b'); Query OK, 1 row affected (0.00 sec)...(0.00 sec) mysql> insert into test_deadlock(id,name) values (3,'c'); Query OK, 1 row affected (0.01...sec) mysql> update test_deadlock set name = 'd' where id = 1; Query OK, 1 row affected (0.01 sec) Rows...> update test_deadlock set name = 'd' where id = 1; Query OK, 1 row affected (0.00 sec) Rows matched:

4344 1

Apache Sentry实战之旅（一）—— Impala+Sentry整合

2.7K4 0

数据库MySQL-事务

(0.05 sec) mysql> insert into bank values ('1001',1000),('1002',1); Query OK, 2 rows affected (0.00...sec) Records: 2 Duplicates: 0 Warnings: 0 -- 开启事务 mysql> begin; Query OK, 0 rows affected (0.00 sec...(0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 -- 提交事务 mysql> commit // Query OK, 0 rows affected...mysql> savepoint a1 // Query OK, 0 rows affected (0.00 sec) mysql> insert into bank values ('1004'...,200) // Query OK, 1 row affected (0.00 sec) -- 回滚到回滚点 mysql> rollback to a1 // Query OK, 0 rows affected

1K1 0

点击加载更多

扫码

添加站长进交流群

领取专属 10元无门槛券

手把手带您无忧上云

mysql的小知识点（关于数据库的导入导出对于windows）

【MySQL】数据库的操作(上)

MySQL二进制日志截取和恢复

MySQL备份恢复

MySQL 事务的隔离级别及锁操作演示

AWS 又瘫痪了。。。本月第三次了。。。：数据中心断电了。。。

数据库MySQL-数据类型

故障分析 | 报错 ERROR 5270 -HY000-- object not in RECYCLE BIN 引发的几个思考

技术分享 | 七个实验掌握 MySQL 8.0 角色功能

mysql-完整性约束

innodb_flush_log_at_trx_commit参数对插入性能的影响测试方法

MySQL事务

MySQL数据insert测试

Mysql系列 - 第4天：DDL常见操作汇总

Go 语言使用 XORM 操作 MySQL 的陷阱

第31期：索引设计（索引数量探讨）

数据库MySQL-列属性

MySQL 死锁后事务无法回滚是真的吗？

Apache Sentry实战之旅（一）—— Impala+Sentry整合

数据库MySQL-事务

扫码

相关资讯

热门标签

活动推荐

运营活动

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐