数据库几个基本操作

数据库几个基本语句（建，查，插，改，删）一直都是自动生成的，xiaolong同学上次去百度面实习的时候就问这种基础问题，所以说，虽然看的多了，自动生成复制粘贴多了，写在纸上试试？我是歇菜了。

建：

CREATE TABLE [meiju] (
[mj_id] [int]  NOT NULL,
[mj_name] [nchar]  NULL,
[mj_season] [int]  NULL,
[mj_num] [int]  NULL,
[mj_type] [nchar]  NULL,
[mj_address] [nchar]  NULL)

插：

CREATE PROCEDURE UP_meiju_ADD
@mj_id int ,
@mj_name nchar(510) ,
@mj_season int ,
@mj_num int ,
@mj_type nchar(510) ,
@mj_address nchar(510) 

 AS
 INSERT INTO meiju(
 [mj_id],[mj_name],[mj_season],[mj_num],[mj_type],[mj_address]
 )VALUES(
 @mj_id,@mj_name,@mj_season,@mj_num,@mj_type,@mj_address
 )

改：

CREATE PROCEDURE UP_meiju_Update
@mj_id int,
@mj_name nchar(510),
@mj_season int,
@mj_num int,
@mj_type nchar(510),
@mj_address nchar(510)
 AS
 UPDATE meiju SET
 [mj_id] = @mj_id,[mj_name] = @mj_name,[mj_season] = @mj_season,[mj_num] = @mj_num,[mj_type] = @mj_type,[mj_address] = @mj_address
 WHERE [ID] = @ID

查：

CREATE PROCEDURE UP_meiju_GetList
 AS
 SELECT
 [mj_id],[mj_name],[mj_season],[mj_num],[mj_type],[mj_address]
  FROM meiju

删：

CREATE PROCEDURE UP_meiju_Delete
@ID int
 AS
 DELETE meiju
  WHERE [ID] = @ID