- 论坛徽章:
- 0
|
我有一个文件可以生成数据库,放在bin 子目录下。
- CREATE DATABASE IF NOT EXISTS books;
- USE books;
- DROP TABLE IF EXISTS authorISBN;
- DROP TABLE IF EXISTS titles;
- DROP TABLE IF EXISTS authors;
- DROP TABLE IF EXISTS publishers;
- CREATE TABLE publishers (
- publisherID INT NOT NULL AUTO_INCREMENT,
- publisherName varchar (30) NOT NULL,
- PRIMARY KEY (publisherID)
- ) TYPE=INNODB
- ;
- CREATE TABLE authors (
- authorID INT NOT NULL AUTO_INCREMENT,
- firstName varchar (20) NOT NULL,
- lastName varchar (30) NOT NULL,
- PRIMARY KEY (authorID)
- ) TYPE=INNODB
- ;
- ...
复制代码
但我怎么执行它呢?
when I am in mysql client just call
- mysql> SOURCE /c:/program files/mysql/mysql server 5.0/bin/books.sql
- ERROR:
- Failed to open file '\c:\program files\mysql\mysql server 5.0\bin\books.sql', er
- ror: 22
- mysql>
复制代码 |
|