sql增添改查（国外英文资料）.doc

sql增添改查（国外英文资料） Create the database The create database LiangshangHeros Use BBB -- use a database The go Create table hero -- the creation table name is hero (heroId int, -- rank HeroName varchar (50) -- the name HeroNickName varchar (50), the nickname Sex char (2) - gender Sal int ) Delete a table (the structure of the table and the tables data are deleted together) Drop table hero -- use SQL statements to add data Insert into hero values (1, song jiang, timely rain, man, 2300) - hero is the name of the table -- use SQL statements to query the data Select * from hero Please delete the gender of the female comrade Delete from hero where sex = man - remove the female comrade -- the table name specification case The table name begins with the letter and _ The table name cannot exceed 128 characters Dont use keywords (reserved words) You can only use the following characters a-z, a-z, 0-9, #, $, _, etc The create table asb Tes1 (int) The create table hero123 (heroId numeric (10, 2)) -- the length is ten, the exact number is two Insert into hero123 values (1.33232) Select * from hero123 The create table abc123 (bir datetime) SQL server provides specialized time functions for us - getdate () Insert into abc123 values (getdate ()) Select * from abc123 The create table haha1234 (cleId int primary key -- the primary key has to be given to the value and cannot be repeated CleName nvarchar (30), The age int ) Insert into hahaha1234 values (1, jia baoyu, 18) Insert into hahaha1234 values (1, jia zheng, 18) - error reporting Insert some fields, and you need to specify the list of fields after the table name Insert into hahaha1234 (cleId, cleName) values (3, Lin daiyu) Select * from haha1234 Insert field Grammar: Insert into table name (field list) values (list of values) Change the field Update student set = man, birthday = 1980-08-01 weher xh = A001 ; The create table haha1234 (cleId int primary key -- the primary key has to be given to the value and cannot be repeated CleNam