澳门新葡萄京娱乐网站-澳门新葡萄京888官网-所有平台

热门关键词: 澳门新葡萄京娱乐网站,澳门新葡萄京888官网

起来实行文书的使用介绍_Mysql_脚本之家澳门新葡

作者: MySQL数据库  发布:2019-12-18

能够在配备文件里钦命mysql运行之后以前实行的SQL文件, 其语法是: 在[mysqld]或者[server]下指定: init-file=D:mysql-5.5.28-winx64abc.sql, 前面为现实的sql文件值 留神上边两点就能够了: 1. 承保您的mysqld 编写翻译的时候从不加 --disable-grant-options 按钮。 2. 管教init-file内定的脚本每行是叁个现实的能够实行的言辞。 为了示例: abc.sql为: 复制代码 代码如下: use test; begin; create table if not exists t123; insert into t123 values; insert into t123 values; select * from t123; -- drop table t123; end; 澳门新葡萄京888官网 ,启航完mysql今后,得到查询: 复制代码 代码如下: mysql> use test; Database changed mysql> select * from t123; +------+ | id | +------+ | 1 | | 2 | +------+ 2 rows in set 其次次开发银行今后,获得结果: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.5.28 MySQL Community Server 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql> use test; Database changed mysql> select * from t123; +------+ | id | +------+ | 1 | | 2 | | 1 | | 2 | +------+ 4 rows in set

本文由澳门新葡萄京娱乐网站发布于MySQL数据库,转载请注明出处:起来实行文书的使用介绍_Mysql_脚本之家澳门新葡

关键词: