您好,欢迎访问一九零五行业门户网

mysql下如何执行sql脚本

欢迎进入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]
其它类似信息

推荐信息