Create the database, the database internal additions and deletions to change the statement

--Create a database with the name banji0425Create Databasebanji0425Go--Apply banji0425 Database Usebanji0425Go--Create a table with the name TongxueCreate TableTongxue (Codeint, nameChar( -), SexChar( -), nianlingint, Fenshudecimal( -,2), DizhiChar( -),)Go--Insert Table ContentsInsert  intoTongxueValues(1,'Liu','male', -, the,'Huantai')GoInsert  intoTongxueValues(2,'Zhang Demin','male', A, the,'Yiyuan')Insert  intoTongxueValues(3,'Ma Zhijie','male', -, -,'Linzi')Insert  intoTongxueValues(4,'Ma Qingxin','male', A, the,'Zhangdian')Insert  intoTongxueValues(5,'Jindong','male', -, the,'Yiyuan')Insert  intoTongxueValues(6,'Gao','male', -, -,'Zhangdian')Insert  intoTongxueValues(7,'Zhang Yuqi','male', -, the,'Yiyuan')Insert  intoTongxueValues(8,'Qixin','male', -, the,'Zhoucun')Insert  intoTongxueValues(9,'Liu Yan Rui','male', -, -,'Zhangdian')Go--querying all the contents of a tableSelect * fromTongxueGo--Query Name columnSelectName fromTongxueGo--querying the contents of name and nianling two columnsSelectName,nianling fromTongxueGo--querying the behavior code3 all contentSelect * fromTongxuewhereCode=3Go--Query the name Fenshu to 85SelectName fromTongxuewhereFenshu= -Go--modified code=3 Fenshu toUpdateTongxueSetFenshu= the whereCode=3GoSelect * fromTongxuewhereCode=3Go--The name of the person whose score is 95 and the age of 24 yearsSelectName fromTongxuewhereFenshu= the  andNianling= -Go

Create the database, the database internal additions and deletions to change the statement