Home > Database > Mysql Tutorial > Mysql基本介绍_MySQL

Mysql基本介绍_MySQL

WBOY
Release: 2016-06-01 13:17:18
Original
1171 people have browsed it

MySQL Workbench 是 MySQL AB 最近释放的可视数据库设计工具。这个工具是设计 MySQL 数据库的专用工具。其充当了DBMS,数据库管理系统的角色。

当用MySQL Workbench进行数据库的批量更新时,执行一个语句会碰到以下错误提示:

Error Code: 1175

You are using safe...without a WHERE that uses a KEY column

因为是MySQL Workbench的默认的安全设置是不能批量更新表的。当要执行的SQL语句是进行批量更新或者删除的时候就会提示这个错误。不能进行批处理。需要我们进行设置,设置如下,打开编辑----选项-----将forbidxxxxx前面的选项去掉即可。

image

 

一些基本介绍:如图所示。

image

 

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template