第11章数据处理之增删改

http练习#1.#1.创建数据库CREATEDATABASEIFNOTEXISTSdbtest11CARACTERSET#2.运行以下 USEdbtest11;CREATEmy_employees(idlast_nameVARCAR(10),useridVARCAR(10),salaryDOUBLE(10,2)CREATETABLEiddepartment_idINT#3显示表my_employees.2345 #5向users #6.将3号员工的last_name修改为#7.将所有工资少 #9.删除my_employees、users#10.#11.#11.清空表#1.创建数据库CREATEDATABASEIFNOTEXISTSdbtest11CARACTERSET#2.运行以下 USEdbtest11;CREATEmy_employees(idfirst_nameVARCAR(10),last_nameVARCAR(10),useridVARCAR(10),salaryDOUBLE(10,2)CREATETABLEiduseridVARCAR(10),department_idINT#3.显示表my_employeesDESCFIRST_NAME 1pa 2 3 4Chad 5 INSERTINTO #DELETEFROMmy_employees;INSERTINTOSELECT1,'pa ',895UNIONALLSELECT2,'Dancs','Betty','Bdancs',860UNIONALLSELECT3,'Biri','Ben','Bbiri',1100UNIONALLSELECT4,' ',750UNIONALLSELECT#5.向34C5INSERTINTOINSERTINTOusersVALUES #6.将3号员工的last_name修改为UPDATEmy_employeesSETlast_name='drelxer'WEREid=#7.将所有工资少 UPDATEmy_employeesSETsalary=1000WERE#8.将userid为Bbiri的user表和my_employeesDELETEFROMusersWEREu.`userid`='Bbiri';#9.删除my_employees、usersDELETEFROMDELETEFROM#10.SELECT*FROMusers;#11.清空表my_employeesfmfmmf##8.查询已经死了的cat ，主人，以 时间1.使用现有数据库dbtest11USEdbtest11;#2.创建表格petCREATETABLEpet(`name`VARC`owner`VARCAR(20),speciesVARCCdeathYEARINSERTINTOINSERTINTO ,birth)#5.将名称为Claws的猫的主人改为#8.查询已经死了的cat 男女男刘男女#3.#3.查询出薪资在1200~1300#4.查询出