估计其中 有单引号吧,比如 update xxx set yyy='asdf'adsasdf'看不到图,直接贴文本吧。
创建数据库脚本:create database pacsdb; grant all on pacsdb.* to 'pacs'@'localhost' identified by 'pacs'; show databases; use pacsdb; mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql 输入了最后一行以后,MySQL并没有继续执行,而是等待输入其它命令,请问这是为什么?是不是我的路径名不正确?还是什么其它的原因
mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql这个是操作系统命令,不是在MYSQL中执行的,需要在WINDOWS的DOS中执行。如果在MYSQL中,则改为mysql> source E:/dcm4chee-2.14.8-mysql/sql/create.mysql
grant all on pacsdb.* to 'pacs'@'localhost' identified by 'pacs';
show databases;
use pacsdb;
mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql
输入了最后一行以后,MySQL并没有继续执行,而是等待输入其它命令,请问这是为什么?是不是我的路径名不正确?还是什么其它的原因
到BIN目录下,再执行。
D:\mysql6\bin>mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql这样。
--------------
E:\MySQL Server 5.0\bin\mysql.exe Ver 14.12 Distrib 5.0.22, for Win32 (ia32)Connection id: 12
Current database: pacsdb
Current user: root@localhost
SSL: Not in use
Using delimiter: cm4chee-2.14.8-
Server version: 5.0.22-community-nt
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 5 hours 14 min 48 secThreads: 1 Questions: 64 Slow queries: 0 Opens: 0 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.003
-------------- ->
->
->
->
->
->问题就是,当输入这些指令以后,还要求输入其它的指令,请问怎么回事?
输入cd E:\MySQL Server 5.0\bin 回车,再输入E: 回车,进入E:\MySQL Server 5.0\bin目录。
再输入mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql 回车。
cd mysql目录\bin
mysql -upacs -ppacs pacsdb < E:/dcm4chee-2.14.8-mysql/sql/create.mysql 回车
mysql> show tables;
+--------------------+
| Tables_in_pacsdb |
+--------------------+
| ae |
| code |
| device |
| files |
| filesystem |
| gppps |
| gpsps |
| gpsps_perf |
| gpsps_req |
| hp |
| hpdef |
| instance |
| media |
| mpps |
| mwl_item |
| other_pid |
| patient |
| priv_file |
| priv_instance |
| priv_patient |
| priv_series |
| priv_study |
| rel_dev_proto |
| rel_gpsps_appcode |
| rel_gpsps_devclass |
| rel_gpsps_devloc |
| rel_gpsps_devname |
| rel_gpsps_gppps |
| rel_hpdef_proc |
| rel_hpdef_reason |
| rel_hpdef_region |
| rel_pat_other_pid |
| rel_study_pcode |
| roles |
| series |
| series_req |
| study |
| study_on_fs |
| study_permission |
| users |
| verify_observer |
+--------------------+
41 rows in set (0.00 sec)