复杂的高频SQL语句&清空表SQL语句清空表所有数据(慎用)
常见SQL语句练习先来看一下表之间的结构和联系创建表结构CREATE TABLE course (cid INT, cname VARCHAR(20), tid INT, PRIMARY KEY(cid)) ENGINE = INNODB;CREATE TABLE teacher (tid INT, tname VARCHAR(20), tcid INT,PRIMARY KEY(tid)) ENGINE = INNODB;CREATE TABLE student (sid INT,
