insert into books (select bookname,publishername,isbn,codeprice,publishdate,authors from books)values(select bookname,publishername,isbn,codeprice,publishdate,authors from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn))消息 156,级别 15,状态 1,第 1 行
关键字 'select' 附近有语法错误。
消息 102,级别 15,状态 1,第 1 行
')' 附近有语法错误。
关键字 'select' 附近有语法错误。
消息 102,级别 15,状态 1,第 1 行
')' 附近有语法错误。
insert into books
select bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001 where not EXISTS
(select * from books where xinbiao001.isbn=books.isbn)
select bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001
where not EXISTS (select * from books where xinbiao001.isbn=books.isbn)
select bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001
where not EXISTS (select * from books where xinbiao001.isbn=books.isbn)
values(select bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn))
select bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn)
这个事干啥用的呢?
bookname,publishername,isbn,codeprice,publishdate,authors from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn))
insert into books (bookname,publishername,isbn,codeprice,publishdate,authors)
(select bookname,publishername,isbn,codeprice,publishdate,authors from xinbiao001
where not EXISTS (select * from books where xinbiao001.isbn=books.isbn))不知道行不? 没有实验
在加个字段如何操作
bookid
让它在老的基础上自增
insert into books(bookid,bookname,publishername,isbn,codeprice,publishdate,authors)
select
(select max(bookid)+1 from books),
bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn)这样不行
提示 不能插入重复键
insert into books(bookname,publishername,isbn,codeprice,publishdate,authors)
select
(select
bookname,publishername,isbn,codeprice,publishdate,authors
from xinbiao001 where not EXISTS (select * from books where xinbiao001.isbn=books.isbn)))