mysql那个版本支持以下的sql

Question

SET FOREIGN_KEY_CHECKS=0;

---

-- Table structure for admin

---

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
username varchar(20) collate utf8_bin NOT NULL,
password varchar(20) collate utf8_bin default NULL,
PRIMARY KEY (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

-- Records of admin

---

INSERT INTO admin VALUES ('admin', 'admin');

---

-- Table structure for t_book

---

DROP TABLE IF EXISTS t_book;
CREATE TABLE t_book (
barcode varchar(20) collate utf8_bin NOT NULL,
book_name varchar(20) collate utf8_bin default NULL,
book_type_id int(11) default NULL,
author varchar(20) collate utf8_bin default NULL,
publish_address varchar(20) collate utf8_bin default NULL,
price float default NULL,
stock_count int(11) default NULL,
PRIMARY KEY (barcode),
KEY FKCB5B1BD4746D52F7 (book_type_id),
CONSTRAINT FKCB5B1BD4746D52F7 FOREIGN KEY (book_type_id) REFERENCES t_book_type (book_type_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Answer 1

试试这个：http://download.csdn.net/detail/xuanzhangran/9785314