数据库几个基本操作

最新推荐文章于 2024-10-26 11:12:48 发布

原创最新推荐文章于 2024-10-26 11:12:48 发布 · 573 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #null #delete #insert #up #table

本文介绍了SQL中常见的基础操作，包括创建表、插入记录、更新记录、查询数据和删除记录等核心语句。通过具体示例展示了如何使用这些语句进行数据库的基本管理。

数据库几个基本语句（建，查，插，改，删）一直都是自动生成的，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