20150929 What to learn: SQL

Server name: Refers to the IP address of the computer where you want to connect the installed database server, if it is the local, it is.

MDF end: Database data files, one database with only one

LDF: Database log files, one database with and at least one

The structure of data stored in a database is stored as a table, and there are many tables in a database

20150929

CREATE DATABASE xuankedata--

go--Connector

Use xuankedata-- using the database

Go

CREATE table student--creating tables

(

code int NOT null,--column name type is empty

Name varchar (20),

Sex int,

Height decimal (18,2)

)

Go

insert into student values(2, ' Zhang San ', 1,1.85)-- input data

Go

Select*from student--Querying the contents of a table

Go

Drop table student-- Delete Tables

Go

Drop Database xuankedata--delete databases , first point to another database, deleted database cannot be in use

Go

Update student set name= ' Zhang San ' where code=2-- Modify the contents of the table, where filter

Go

Delete from student where name= ' John Doe '-- delete data from table

Go

20150929 What to learn: SQL