CREATE TABLE ClubActivity ( activity_name VARCHAR(50) PRIMARY KEY, activity_content VARCHAR(255) NOT NULL, activity_capacity INT NOT NULL, activity_sponsor VARCHAR(50) NOT NULL, activity_time DATETIME NOT NULL, activity_tool VARCHAR(50) NOT NULL, activity_location VARCHAR(50) NOT NULL, activity_fund DECIMAL(10,2) NOT NULL, admin_accountd VARCHAR(50) NOT NULL, club_namea VARCHAR(50) NOT NULL, FOREIGN KEY (admin_accountd) REFERENCES Admin(admin_account), FOREIGN KEY (club_namea) REFERENCES Club(club_name) );给这个表插入十条数据语句
时间: 2024-03-07 07:51:31 浏览: 200
CreateTable.rar_create table ja_createTab_createTable
很抱歉,我是一个语言模型AI,没有具体的数据库操作权限。但是我可以给你提供一下插入数据的模板语句,你可以根据自己的实际情况进行修改:
INSERT INTO ClubActivity (activity_name, activity_content, activity_capacity, activity_sponsor, activity_time, activity_tool, activity_location, activity_fund, admin_accountd, club_namea) VALUES
('Activity 1', 'Content 1', 50, 'Sponsor 1', '2021-07-01 09:00:00', 'Tool 1', 'Location 1', 1000.00, 'admin1', 'club1'),
('Activity 2', 'Content 2', 100, 'Sponsor 2', '2021-07-02 14:00:00', 'Tool 2', 'Location 2', 2000.00, 'admin2', 'club2'),
('Activity 3', 'Content 3', 80, 'Sponsor 3', '2021-07-03 10:30:00', 'Tool 3', 'Location 3', 1500.00, 'admin3', 'club3'),
('Activity 4', 'Content 4', 120, 'Sponsor 4', '2021-07-04 13:45:00', 'Tool 4', 'Location 4', 3000.00, 'admin4', 'club4'),
('Activity 5', 'Content 5', 60, 'Sponsor 5', '2021-07-05 11:00:00', 'Tool 5', 'Location 5', 1200.00, 'admin5', 'club5'),
('Activity 6', 'Content 6', 90, 'Sponsor 6', '2021-07-06 15:20:00', 'Tool 6', 'Location 6', 1800.00, 'admin6', 'club6'),
('Activity 7', 'Content 7', 70, 'Sponsor 7', '2021-07-07 12:10:00', 'Tool 7', 'Location 7', 1400.00, 'admin7', 'club7'),
('Activity 8', 'Content 8', 110, 'Sponsor 8', '2021-07-08 16:30:00', 'Tool 8', 'Location 8', 2500.00, 'admin8', 'club8'),
('Activity 9', 'Content 9', 50, 'Sponsor 9', '2021-07-09 09:30:00', 'Tool 9', 'Location 9', 1000.00, 'admin9', 'club9'),
('Activity 10', 'Content 10', 100, 'Sponsor 10', '2021-07-10 14:45:00', 'Tool 10', 'Location 10', 2000.00, 'admin10', 'club10');
阅读全文