Get the App
SLTechnology News&Howtos  ›  Database  › 

2. SQLMY-create a course schedule and insert data into the table

Shulou Source: shulou.com Published: 2022-06-01 04:03:10 10月01日 Update

Create a course schedule and insert data into the table

-- create a new curriculum. Tid is the teacher's number.

Create table Course (Cid varchar (10), Cname nvarchar (10), Tid varchar (10))

-- insert data into the table

Insert into Course values ('01',' Chinese', '02')

Insert into Course values ('02',' Mathematics', '01')

Insert into Course values ('03',' English', '03')

Tags: Data curriculum curriculum interpolation teachers math Chinese English Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Docker macOS Shulou Information Huawei