我的SQL语句,请问怎么改改?:
CREATE OR REPLACE VIEW
书籍总览
AS SELECT DISTINCT
b.id ,b.name 书名,b.cid 类目编号,t.type 类型,b.price 价格,b.time 导入时间
FROM
shbooks AS b,shtype AS t
WHERE
b.cid=t.id;
被联合的两个表属性:
CREATE TABLE `shbooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` char(50) DEFAULT NULL,
`cid` int(10) unsigned DEFAULT '0',
`price` float(5,2) DEFAULT NULL,
`time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;
CREATE TABLE `shtype` (
`id` int(10) unsigned NOT NULL,
`type` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
我写上了,我试了试,用cmd 也没有影响..这个视图没主键无所谓是吧..