SLTechnology News&Howtos › Database ›

4. SQLMY-create a score sheet and insert data into the table

Shulou Source: shulou.com Published: 2022-06-01 18:27:49 09月10日 Update

-- create a score sheet and insert data into the table

Create table SC (Scid varchar (10), Cid varchar (10), score decimal (18d1))

-- insert data into the table

Insert into SC values ('01',' 01', 80)

Insert into SC values ('01',' 02', 90)

Insert into SC values ('01',' 03', 99)

Insert into SC values ('02','01', 70)

Insert into SC values ('02','02', 60)

Insert into SC values ('02',' 03', 80)

Insert into SC values ('03',' 01', 80)

Insert into SC values ('03','02', 80)

Insert into SC values ('03',' 03', 80)

Insert into SC values ('04','01', 50)

Insert into SC values ('04',' 02', 30)

Insert into SC values ('04',' 03', 20)

Insert into SC values ('05',' 01', 76)

Insert into SC values ('05',' 02', 87)

Insert into SC values ('05',' 03', 88)

Insert into SC values (06', 01', 31)

Insert into SC values ('06',' 03', 34)

Insert into SC values ('07',' 02', 89)

Insert into SC values ('07',' 03', 98)

Insert into SC values ('08',' 01', 90)

Insert into SC values ('08',' 02', 88)