Forum Discussion
INSERT Multiuple Rows Not Working
I have a query (executed from a macro) as follows: INSERT INTO PatronsWork (PatronID) SELECT DISTINCT EventAttendance.PatronID FROM EventAttendance; I get nothing inserted. If I remove the...
CREATE TABLE EventAttendance (`PatronID` long);
INSERT INTO `EventAttendance` VALUES ('12');
INSERT INTO `EventAttendance` VALUES ('12');
select * FROM EventAttendance;
CREATE TABLE PatronsWork (`PatronID` long);
INSERT INTO PatronsWork (PatronID)
SELECT DISTINCT EventAttendance.PatronID
FROM EventAttendance;
select * from PatronsWork;
On problem on myside.
online test
http://anyoupin.cn/bsbm/stu60/sqlDao/sqlEditor_dao.html
select * FROM EventAttendance;
PatronID
12
12
INSERT INTO PatronsWork (PatronID)SELECT DISTINCT EventAttendance.PatronID FROM EventAttendance;
select * from PatronsWork;
PatronID
12
INSERT INTO `EventAttendance` VALUES ('12');
INSERT INTO `EventAttendance` VALUES ('12');
select * FROM EventAttendance;
CREATE TABLE PatronsWork (`PatronID` long);
INSERT INTO PatronsWork (PatronID)
SELECT DISTINCT EventAttendance.PatronID
FROM EventAttendance;
select * from PatronsWork;
On problem on myside.
online test
http://anyoupin.cn/bsbm/stu60/sqlDao/sqlEditor_dao.html
select * FROM EventAttendance;
PatronID
12
12
INSERT INTO PatronsWork (PatronID)SELECT DISTINCT EventAttendance.PatronID FROM EventAttendance;
select * from PatronsWork;
PatronID
12