1 DROP DATABASE IF EXISTS EBook;
2
3 create database EBook
4 on primary
5 (
6 name=EBooks,
7 filename='D:\\DB\EBooks.mdf',
8 filegrowth=10%,
9 size=10
10 )
11
12 log on
13 (
14 name=EBook_log,
15 filename='D:\\DB\EBook_log.ldf',
16 filegrowth=10%,
17 size=10
18 )
在创建数据库时,第四行on显示“on is not valid at this position, expecting EOF" 。
错误提示:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on primary key ( name='EBook', filename='D:\DB\EBook.mdf', filegrowth=10%, size' at line 2