当前位置:Gxlcms > mysql > mysql下如何执行sql脚本

mysql下如何执行sql脚本

时间:2021-07-01 10:21:17 帮助过:3人阅读

欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入 进入MySql,选择数据库drpItem,执行source E:\struts_training_itemmgr.sql,如下所示: Enter password: ******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection

欢迎进入Linux社区论坛,与200万技术人员互动交流 >>进入

  进入MySql,选择数据库drpItem,执行source E:\struts_training_itemmgr.sql,如下所示:

  Enter password: ********

  Welcome to the MySQL monitor. Commands end with ; or \g.

  Your MySQL connection id is 110

  Server version: 5.0.77-community-nt MySQL Community Edition (GPL)

  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

  mysql> use drpItem;

  Database changed

  mysql> source E:\struts_training_itemmgr.sql

  Query OK, 0 rows affected (0.03 sec)

  Query OK, 0 rows affected (0.05 sec)

  Query OK, 0 rows affected (0.09 sec)

  Query OK, 0 rows affected (0.08 sec)

  Query OK, 1 row affected (0.03 sec)

  Query OK, 1 row affected (0.03 sec)

  Query OK, 1 row affected (0.03 sec)

  Query OK, 1 row affected (0.03 sec)

  Query OK, 1 row affected (0.02 sec)

  Query OK, 1 row affected (0.03 sec)

  Query OK, 1 row affected (0.03 sec)

  mysql>

[1] [2]

人气教程排行