You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
1.8 KiB
19 lines
1.8 KiB
CREATE TABLE `维修` (
|
|
`维修编号` VARCHAR(10) NOT NULL,
|
|
`设备编号` VARCHAR(10) NOT NULL,
|
|
`维修人员` VARCHAR(50) NOT NULL,
|
|
`维修时间` DATE NOT NULL,
|
|
`维修成本` DECIMAL(10, 2) NOT NULL,
|
|
PRIMARY KEY (`维修编号`)
|
|
);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP001', 'DEV001', '张三', '2023-01-01', 550.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP002', 'DEV002', '李四', '2023-01-02', 600.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP003', 'DEV003', '王五', '2023-01-03', 700.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP004', 'DEV004', '赵六', '2023-01-04', 800.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP005', 'DEV005', '张三', '2023-01-05', 550.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP006', 'DEV006', '李四', '2023-01-06', 650.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP007', 'DEV007', '王五', '2023-01-07', 750.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP008', 'DEV008', '赵六', '2023-01-08', 850.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP009', 'DEV009', '张三', '2023-01-09', 500.00);
|
|
INSERT INTO `维修`(`维修编号`, `设备编号`, `维修人员`, `维修时间`, `维修成本`) VALUES ('REP010', 'DEV010', '李四', '2023-01-10', 600.00);
|