Shulou(Shulou.com)06/01 Report--

Create database db001

-- create tables

Create table job (

Id char (10) not null,name char (30) not null,address char

);

-- delete the table

Drop table jobtable2

-- insert numeric value

Use db0001

Go

Insert into job values ('1', 2', 3')

Insert into job values ('2pm, 2m, etc.)

-- insert numeric value

Use db001

Insert into job values ('2pm, 2m, etc.)

Insert into job values ('10001mm,' zhangsan', 'sex')

-- create tables

Create table cjtb (id char (30), name char (30), sex char (30)

);

-- insert numeric value

Insert into cjtb values ('10002 million,' zhangsan', 'sex')

Insert into cjtb values ('10003miles,' zhangsan', 'sex')

Insert into cjtb values ('10004 million,' zhangsan', 'sex')

Insert into cjtb (id,name,sex) values ('10005 years, 1 005, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 3, 5, 5, 3, 5, 5, 4, 5, 5, 3, 5, 5, 2, 3, 5, 5, 5, 4, 5, 5, 2, 5, 2, 5, 2, 5, 5, 5, 5, 4, 4, 2, 2, 5, 2, 5, 5, 5, 5, 5, 5, 4, 2, 2, 4, 2, 2, 3, 2, 4, 4, 4, 2, 4, 4, 2, 4, 4, 4, 4, 4, 4, 2, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4

-- modify the numerical value

UPDATE cjtb SET name = 'wangmazi' WHERE id =' 6'

-- query table

Select * from cjtb

-create a view

CREATE VIEW V_Customer

AS SELECT id, name, sex

FROM cjtb

Drop database database name-delete database drop table table name-delete table from table name where condition-delete data truncate table table name is also delete database. But he can judge the sequence. You'll see if you compare it with the sequence.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.