// 创建表格
CREATE TABLE category(id int IDENTITY(1, 1) PRIMARY KEY not null,cname char(50))
// 在表格中添加数据
INSERT INTO category(id, cname) VALUES(@id, '@name')
// 表格中更新数据
UPDATE category SET cname = @cname WHERE id = @id;
// 表格中删除数据
DELETE FROM category WHERE id = '@id'
// 读取数据
select * from category where id = '@id'
评论